COALESCE function [Miscellaneous]

Returns the first non-NULL expression from a list. This function is identical to the ISNULL function.

 Syntax
 Parameters
 Returns
 Remarks
 See also
 Standards and compatibility
 Example