Functions in SELECT statements

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.

For information about the syntax of the following SQL functions and other SQL functions, see the Expressions segment in the HCL OneDB™ Guide to SQL: Syntax.
Tip: You can also use functions that you create yourself. For information about user-defined functions, see Create and use SPL routines, and HCL OneDB User-Defined Routines and Data Types Developer's Guide.