how to replace null values in sql with customize value
ISNULL:-Replaces NULL value with the specified replacement value.
COALESCE:-Returns the first nonnull expression among its arguments.
For e.g.
CASE Statement:-Evaluates a list of conditions and returns one of multiple possible result expressions.
For e.g.
No comments:
Post a Comment