User's Guide

Part VI. SQL Anywhere Reference

About this chapter

This chapter describes the built-in functions supported by SQL Anywhere. Functions are used to return information from the database. They are allowed anywhere an expression is allowed.

NULL value Unless otherwise stated, any function that receives the NULL value as a parameter returns a NULL value.

For more information

Some of the functions listed have Transact-SQL equivalents that are not listed here. For a description of Transact-SQL functions supported by SQL Anywhere, see the chapter "Using Transact-SQL with SQL Anywhere".

Aggregate functions

Numeric functions

String functions

Date and time functions

Data type conversion functions

System functions

Miscellaneous functions