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]
PI function [Numeric]
POWER function [Numeric]
QUARTER function [Date and time]
RADIANS function [Numeric]
REMAINDER function [Numeric]
REPEAT function [String]
REPLACE function [String]
REPLICATE function [String]
RIGHT function [String]
ROUND function [Numeric]
RTRIM function [String]
SECOND function [Date and time]
SECONDS function [Date and time]
SHORT_PLAN function [Miscellaneous]
SIGN function [Numeric]
SIMILAR function [String]
SIN function [Numeric]
SOUNDEX function [String]
SPACE function [String]
SQRT function [Numeric]
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]
SYNC_PROFILE_OPTION_VALUE function [System]
TAN function [Numeric]
TODAY function [Date and time]
TRIM function [String]
TRUNCNUM function [Numeric]
TSEQUAL function [System] (deprecated)
UCASE function [String]
UPPER function [String]
USER_ID function [System]
USER_NAME function [System]
UUIDTOSTR function [String]
WEEKS function [Date and time]
YEAR function [Date and time]
YEARS function [Date and time]
YMD function [Date and time]