Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ujar COALESCE Vs ISNULL RE: COALESCE Vs ISNULL
Mike John
SSCertifiable
Points: 7186
More actions
November 12, 2010 at 12:19 am
#1249851
Because in this case ALL the arguments are "untyped" nulls.
so
declare @a int
select coalesce(@a,null)
will retunr NULL (and not an error).
Mike