NZ function in SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jason Gentry
    New Member
    • Aug 2012
    • 1

    NZ function in SQL

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

    Code:
    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;
    Last edited by Rabbit; Aug 8 '12, 05:55 PM. Reason: Please use code tags when posting code.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Please use code tags when posting code.

    The equivalent function in SQL Server is ISNULL.

    Comment

    Working...