In addition to column names and operators, an expression can also include one or more functions. This chapter shows how to use functions in SELECT statements to perform more complex database queries and data manipulation. This chapter includes: aggregates functions, time functions, date-conversion functions, the cardinality function, smart-large-object functions, string-manipulation functions, data encryption functions, and other functions.
For information about the syntax of the following SQL functions and other SQL functions, see the Expressions segment in the IBM Informix: Guide to SQL Syntax.