Posted by SQL on 10/02/19 11:45

use coalesce or isnull

declare @v int
select coalesce(@v,0),isnull(@v,0)


Denis the SQL Menace
http://sqlservercode.blogspot.com/

• Next in forum: Re: Undo last statement
• Prev in forum: Any functions to replace NZ in SQL Server?
• Thread view: Re: Any functions to replace NZ in SQL Server?

[Reply to this message]