Calling user-defined functions

A user-defined function can be used, subject to permissions, in any place you would use a built-in non-aggregate function.

The following statement in Interactive SQL returns a full name from two columns containing a first and last name:

SELECT FullName(GivenName, Surname) 
 AS "Full Name"
 FROM Employees;
Full Name
Fran Whitney
Matthew Cobb
Philip Chin
...

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

SELECT FullName('Jane', 'Smith') 
 AS "Full Name";
Full Name
Jane Smith

Any user who has been granted EXECUTE permissions for the function can use the FullName function.

 Example
 Notes