By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,948 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,948 IT Pros & Developers. It's quick & easy.

NZ function in SQL

P: 1
How would I rewrite this to be compatible with T-SQL?

Expand|Select|Wrap|Line Numbers
  1. SELECT Challenges.*, ChallengeStatus(nz([Type],0),nz([Initiated Date],0),nz([OrderedDate],0),nz([DeliveredDate],0),nz([AnsweredDate],0),nz([Completed Date],0),nz([CanceledDate],0)) AS Status FROM Challenges ORDER BY Challenges.ID;
Aug 8 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,430
Please use code tags when posting code.

The equivalent function in SQL Server is ISNULL.
Aug 8 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.