Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ujar COALESCE Vs ISNULL RE: COALESCE Vs ISNULL
Mike Is Here
Hall of Fame
Points: 3348
More actions
November 12, 2010 at 7:26 am
#1250005
ISNULL and COALESCE though equivalent, can behave differently. An expression involving ISNULL with non-null parameters is considered to be NOT NULL, while expressions involving COALESCE with non-null parameters is considered to be NULL.