Calling User-Defined Functions

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

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Stored Procedures and Triggers > Using procedures, triggers, and batches > Introduction to user-defined functions > Calling user-defined functions.

Sybase IQ example

Note:

For examples, use the Sybase IQ demo database iqdemo.db.

SELECT fullname (GivenName, SurName)FROM Employees;

fullname (GivenName, SurName)

Fran Whitney Matthew Cobb Philip Chin...

Parent topic: Introduction to User-Defined Functions