Calling User-Defined Functions

You can use user-defined functions, subject to permissions, in the same places you would use built-in nonaggregate functions.

This Interactive SQL statement returns a full name from two columns containing a first and last name:

SELECT fullname (GivenName, LastName)
FROM Employees;

fullname (Employees.GivenName,Employees.LastName)
Fran Whitney
Matthew Cobb
Philip Chin
...

The following statement returns a full name from a supplied first and last name:

SELECT fullname ('Jane', 'Smith');

fullname ('Jane','Smith')
Jane Smith

Any user who has been granted Execute permissions for the function can use the fullname function.