Built-In Scalar Functions

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

& (bitwise AND) ~ (bitwise NOT) | (bitwise OR) << (bitwise shift left) >> (bitwise shift right) XOR (bitwise 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 ASCII SIGN CHR