Scalar functions take a list of scalar arguments and return a single scalar value.
Scalar functions take one or more expression values as arguments and return a single result value for each row of data processed by a query. These functions can appear in most expressions, and are used most often in SELECT clauses and WHERE clauses.