skip to main content
Querying data stores with SQL : Supported scalar functions
  

Try Now

Supported scalar functions

Support for scalar functions differs depending on the data store you are accessing. Each scalar function returns a single value based on the input value. The SQLGetInfo function returns information about supported functions.
Applications can construct SQL statements using the following syntax, where scalar-function is one of the functions listed in the topic for your data store.
{fn scalar-function}
For example:
SELECT {fn
UCASE(NAME)} FROM EMP
* Scalar Function Support for Amazon Redshift
* Scalar Function Support for Apache Hive
* Scalar Function Support for DB2
* Scalar Function Support for Google Analytics
* Scalar Function Support for Greenplum
* Scalar Function Support for Informix
* Scalar Function Support for Microsoft Dynamics
* Scalar Function Support for Microsoft SQL Server
* Scalar Function Support for MySQL
* Scalar Function Support for Oracle
* Scalar function support for Oracle Marketing Cloud (Eloqua)
* Scalar Function Support for Oracle Sales Cloud
* Scalar Function Support for Oracle Service Cloud
* Scalar Function Support for PostgeSQL
* Scalar Function Support for Progress OpenEdge
* Scalar Function Support for Progress Rollbase
* Scalar Function Support for Salesforce-based data stores
* Scalar Function Support for SugarCRM
* Scalar Function Support for Sybase