A user-defined function can be used, subject to permissions, in any place you would use a built-in nonaggregate function.
See ”Calling user-defined functions” in SQL Anywhere Server - SQL Usage.
For examples, use the Sybase IQ demo database iqdemo.db. For installation information, see “The demo database”.
SELECT fullname (GivenName, SurName)FROM Employees;
fullname (GivenName, SurName)
Fran WhitneyMatthew CobbPhilip Chin...