Roger's Access Blog
Thoughts, opinions, samples, tips, and tricks about Microsoft Access
Thursday, July 7, 2016
Access NZ() function to SQL Server equivalent
What is the SQL Server equivalent to Access NZ() function?
Access SQL
NZ([Event Timestamp])
SQL Server Equivalent
COALESCE([Event Timestamp],0)
ISNULL([Event Timestamp],0)
do not confuse this with the Access isnull() function.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment