Daily Archives: April 10, 2013

Difference between ISNULL and COALESCE

ISNULL ISNULL ¬†function returns null value with replacement value. Syntax : ISNULL(expression_value,replacement_value) It will take only 2 parameters or arguments.First it will check the expression value if its null then it will return replacement value. Eg : Declare @value varchar(10) Set @value = 10 Select ISNULL(@value,’n/a’) as Demo In the above scenario the output is […]