Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Using procedures, triggers, and batches » The structure of procedures and triggers

 

Passing parameters to functions

User-defined functions are not invoked with the CALL statement, but are used in the same manner that built-in functions are. For example, the following statement uses the FullName function defined in Creating user-defined functions to retrieve the names of employees:

 To list the names of all employees
  • In Interactive SQL, type the following:

    SELECT FullName( GivenName, Surname ) AS Name
       FROM Employees;
Name
Fran Whitney
Matthew Cobb
Philip Chin
Julie Jordan
...
 Notes