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 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 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