Home Forums SQL Server 7,2000 T-SQL How to return a 0 value instead of null RE: How to return a 0 value instead of null

  • September 3, 2004 at 1:22 am

    #521590

    A neat function that I have used is Coalesce.

     

    SELECT COALESCE(NULL,0) AS [Result] (where NULL=field of choice)