Built-In Scalar Functions

The Built-In Scalar Functions page describes functions that return one value per call:

AND NOT OR SHIFT_LEFT SHIFT_RIGHT XOR BETWEEN CASE COALESCE DECODE IN IS_ASCII IS NULL ISNULL FROM_UNIXTS, FROM_UNIXTSMS TO_HEX

TO_UNIXTS, TO_UNIXTSMS CURDATE CURRENT_DATE CURRENT_TIMESTAMP DATEADD DATEDIFF DATEPART EOMONTH EXTRACT GETDATE SYSDATE TRUNC ABS ACOS ASIN ATAN

ATN2 CEILING / CEIL COS COT CRC64 DEGREES EXP FLOOR LOG LOG10 MOD, % PI POWER RADIANS ROUND SIN

SQRT SQUARE TAN TRUNC CHARACTER_LENGTH / CHAR_LENGTH CHARINDEX || (Concatenate) ISPREFIXOF LEFT LEN LIKE LOWER LTRIM OCTET_LENGTH PATINDEX

REGEXP_COUNT REGEXP_INSTR REGEXP_REPLACE REGEXP_SUBSTR REPEAT REPLACE REVERSE RIGHT RLIKE RTRIM SUBSTRING TRIM UPPER SELECT ASCII SIGN