String functions
Topics
- || (Concatenation) operator
- ASCII function
- BPCHARCMP function
- BTRIM function
- BTTEXT_PATTERN_CMP function
- CHAR_LENGTH function
- CHARACTER_LENGTH function
- CHARINDEX function
- CHR function
- COLLATE function
- CONCAT function
- CRC32 function
- DIFFERENCE function
- INITCAP function
- LEFT and RIGHT functions
- LEN function
- LENGTH function
- LOWER function
- LPAD and RPAD functions
- LTRIM function
- OCTETINDEX function
- OCTET_LENGTH function
- POSITION function
- QUOTE_IDENT function
- QUOTE_LITERAL function
- REGEXP_COUNT function
- REGEXP_INSTR function
- REGEXP_REPLACE function
- REGEXP_SUBSTR function
- REPEAT function
- REPLACE function
- REPLICATE function
- REVERSE function
- RTRIM function
- SOUNDEX function
- SPLIT_PART function
- STRPOS function
- STRTOL function
- SUBSTRING function
- TEXTLEN function
- TRANSLATE function
- TRIM function
- UPPER function
String functions process and manipulate character strings or expressions that evaluate to character strings. When the string argument in these functions is a literal value, it must be enclosed in single quotation marks. Supported data types include CHAR and VARCHAR.
The following section provides the function names, syntax, and descriptions for supported functions. All offsets into strings are one-based.
Deprecated leader node-only functions
The following string functions are deprecated because they run only on the leader node. For more information, see Leader node–only functions
-
GET_BYTE
-
SET_BIT
-
SET_BYTE
-
TO_ASCII