# String functions
<a name="String_functions_spark"></a>

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. 

**Topics**
+ [\|\| (Concatenation) operator](concat_op.md)
+ [BTRIM function](BTRIM.md)
+ [CONCAT function](CONCAT.md)
+ [FORMAT\_STRING function](FORMAT_STRING.md)
+ [LEFT and RIGHT functions](LEFT.md)
+ [LENGTH function](LENGTH.md)
+ [LOWER function](LOWER.md)
+ [LPAD and RPAD functions](LPAD.md)
+ [LTRIM function](LTRIM.md)
+ [POSITION function](POSITION.md)
+ [REGEXP\_COUNT function](REGEXP_COUNT.md)
+ [REGEXP\_INSTR function](REGEXP_INSTR.md)
+ [REGEXP\_REPLACE function](REGEXP_REPLACE.md)
+ [REGEXP\_SUBSTR function](REGEXP_SUBSTR.md)
+ [REPEAT function](REPEAT.md)
+ [REPLACE function](REPLACE.md)
+ [REVERSE function](REVERSE.md)
+ [RTRIM function](RTRIM.md)
+ [SPLIT function](split.md)
+ [SPLIT\_PART function](SPLIT_PART.md)
+ [SUBSTRING function](SUBSTRING.md)
+ [TRANSLATE function](TRANSLATE.md)
+ [TRIM function](TRIM.md)
+ [UPPER function](UPPER.md)
+ [UUID function](UUID.md)