String functions

Topics

• || (Concatenation) operator
• BTRIM function
• CHAR_LENGTH function
• CHARACTER_LENGTH function
• CHARINDEX function
• CONCAT function
• LEFT and RIGHT functions
• LEN function
• LENGTH function
• LOWER function
• LPAD and RPAD functions
• LTRIM function
• POSITION 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
• SUBSTR 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.