Scalar Functions take a list of scalar arugments and return a single scalar value.
Scalar functions can appear in the select list of the SELECT clause as well as in the WHERE and HAVING clauses.
Most scalar functions return Null when called with a Null argument. Exceptions include COALESCE() and many of the XML functions.