Null-handling Functions
SQL defines two functions to explicitly handle Nulls: NULLIF
and COALESCE
. Both functions are abbreviations for searched CASE
expressions.
Read more about this topic: Null (SQL)
Famous quotes containing the word functions:
“Those things which now most engage the attention of men, as politics and the daily routine, are, it is true, vital functions of human society, but should be unconsciously performed, like the corresponding functions of the physical body.”
—Henry David Thoreau (18171862)