Defining and Using Functions › When to Use a User-Defined Function

When to Use a User-Defined Function

You can use a user-defined SQL function just as you would use any SQL scalar function. A scalar function is a function whose argument includes zero or more value expressions on which the function operates. The result of a scalar function is a single value. This value is derived from the expression or expressions named in the arguments.