# String Functions

```{toctree}
:maxdepth: 1
:titlesonly:

BIN() <bin>
BIT_LENGTH() <bit-length>
CHAR_LENGTH() <char-length>
CONCAT() <concat>
CONCAT_WS() <concat-ws>
EMPTY() <empty>
ENDSWITH() <endswith>
FIELD() <field>
FIND_IN_SET() <find-in-set>
FORMAT() <format>
FROM_BASE64() <from_base64>
HEX() <hex>
INSTR() <instr>
LCASE() <lcase>
LEFT() <left>
LENGTH() <length>
LOCATE() <locate>
LOWER() <lower>
LPAD() <lpad>
LTRIM() <ltrim>
MD5() <md5>
OCT() <oct>
REPEAT() <repeat>
REVERSE() <reverse>
RPAD() <rpad>
RTRIM() <rtrim>
SHA1()/SHA() <sha1>
SHA2() <sha2>
SPACE() <space>
SPLIT_PART() <split_part>
STARTSWITH() <startswith>
SUBSTRING() <substring>
SUBSTRING_INDEX() <substring-index>
TO_BASE64() <to_base64>
TRIM() <trim>
UCASE() <ucase>
UNHEX() <unhex>
UPPER() <upper>
Regular Expression Overview <Regular-Expressions/index>
```