Pages

Friday, April 25, 2008

ISNULL() vs. COALESCE()

ISNULL() and COALESCE()
In dealing with NULL values in SQL Server, the developer is often faced with the requirement to evaluate the content of a field, and when said field in null, return another value (or field). There are two functions in SQL Server which support this requirement: ISNULL() and COALESCE().

No comments:

Post a Comment