Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions


SQL functions (P-Z)

Each function is listed, and the function type (numeric, character, and so on) is indicated next to it.

For links to all functions of a given type, see Function types.

See also

PATINDEX function [String]
PERCENT_RANK function [Ranking]
PI function [Numeric]
PLAN function [Miscellaneous]
POWER function [Numeric]
PROPERTY function [System]
PROPERTY_NAME function [System]
PROPERTY_NUMBER function [System]
QUARTER function [Date and time]
RADIANS function [Numeric]
RAND function [Numeric]
RANK function [Ranking]
READ_CLIENT_FILE function [String]
REGEXP_SUBSTR function [String]
REGR_AVGX function [Aggregate]
REGR_AVGY function [Aggregate]
REGR_COUNT function [Aggregate]
REGR_INTERCEPT function [Aggregate]
REGR_R2 function [Aggregate]
REGR_SLOPE function [Aggregate]
REGR_SXX function [Aggregate]
REGR_SXY function [Aggregate]
REGR_SYY function [Aggregate]
REMAINDER function [Numeric]
REPEAT function [String]
REPLACE function [String]
REPLICATE function [String]
REVERSE function [String]
REWRITE function [Miscellaneous]
RIGHT function [String]
ROUND function [Numeric]
ROWID function [Miscellaneous]
ROW_NUMBER function [Miscellaneous]
RTRIM function [String]
SECOND function [Date and time]
SECONDS function [Date and time]
SET_BIT function [Bit array]
SET_BITS function [Aggregate]
SIGN function [Numeric]
SIMILAR function [String]
SIN function [Numeric]
SORTKEY function [String]
SOUNDEX function [String]
SPACE function [String]
SQLDIALECT function [Miscellaneous]
SQLFLAGGER function [Miscellaneous]
SQRT function [Numeric]
STDDEV function [Aggregate]
STDDEV_POP function [Aggregate]
STDDEV_SAMP function [Aggregate]
STR function [String]
STRING function [String]
STRTOUUID function [String]
STUFF function [String]
SUBSTRING function [String]
SUM function [Aggregate]
SUSER_ID function [System]
SUSER_NAME function [System]
TAN function [Numeric]
TEXTPTR function [Text and image]
TO_CHAR function [String]
TO_NCHAR function [String]
TODAY function [Date and time]
TRACEBACK function [Miscellaneous]
TRACED_PLAN function [Miscellaneous]
TRANSACTSQL function [Miscellaneous]
TRIM function [String]
TRUNCNUM function [Numeric]
TSEQUAL function [System] (deprecated)
UCASE function [String]
UNICODE function [String]
UNISTR function [String]
UPPER function [String]
USER_ID function [System]
USER_NAME function [System]
UUIDTOSTR function [String]
VAR_POP function [Aggregate]
VAR_SAMP function [Aggregate]
VARIANCE function [Aggregate]
VAREXISTS function [Miscellaneous]
WATCOMSQL function [Miscellaneous]
WEEKS function [Date and time]
WRITE_CLIENT_FILE function [String]
XMLAGG function [Aggregate]
XMLCONCAT function [String]
XMLELEMENT function [String]
XMLFOREST function [String]
XMLGEN function [String]
YEAR function [Date and time]
YEARS function [Date and time]
YMD function [Date and time]