The following table lists the system functions that ODBC supports.

Table 1. Scalar System Functions
Function Returns
DATABASE() Name of the database, corresponding to the connection handle (hdbc).
IFNULL(exp,value) value, if exp is null.
USER() Authorization name of the user.