Transact-SQL: ISNULL(), COALESCE()

COALESCE(Transact-SQL): Returns the first nonnull expression among its arguments.

ISNULL(Transact-SQL): Replaces NULL with the specified replacement value.