What is a Function?
What is a SQL Function and how to use a function in a T-SQL statement? We use the GetDate() and LEFT() functions as examples.
Function
SQL COALESCE Function
The SQL Coalesce function is used when you want to combine values from a series of columns or expressions when they might contain NULL values.