# String Functions

## In this section

* [AES\_DECRYPT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/aes-decrypt.md)
* [AES\_ENCRYPT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/aes-encrypt.md)
* [ASCII](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/ascii.md)
* [BIN](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/bin.md)
* [BINARY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/binary.md)
* [CHAR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/char.md)
* [CHARACTER\_LENGTH](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/character-length.md)
* [CHARSET](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/charset.md)
* [CONCAT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/concat.md)
* [CONCAT\_WS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/concat-ws.md)
* [CRC32](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/crc-32.md)
* [FIELD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/field.md)
* [FORMAT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/format.md)
* [FROM\_BASE64](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/from-base-64.md)
* [QUOTE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/quote.md)
* [HEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/hex.md)
* [INET\_ATON](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/inet-aton.md)
* [INET\_NTOA](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/inet-ntoa.md)
* [INET6\_ATON](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/inet-6-aton.md)
* [INET6\_NTOA](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/inet-6-ntoa.md)
* [INITCAP](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/initcap.md)
* [INSTR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/instr.md)
* [LCASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/lcase.md)
* [LEFT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/left.md)
* [LENGTH](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/length.md)
* [LOCATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/locate.md)
* [LPAD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/lpad.md)
* [LTRIM](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/ltrim.md)
* [MD5](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/md-5.md)
* [REPLACE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/replace.md)
* [REVERSE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/reverse.md)
* [RIGHT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/right.md)
* [RPAD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/rpad.md)
* [RTRIM](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/rtrim.md)
* [SECRET](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/secret.md)
* [SHA1](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/sha-1.md)
* [SHA2](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/sha-2.md)
* [SPLIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/split.md)
* [STRING\_BYTES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/string-bytes.md)
* [SUBSTRING](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/substring.md)
* [SUBSTRING\_INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/substring-index.md)
* [TO\_BASE64](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/to-base-64.md)
* [TRIM](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/trim.md)
* [UCASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/ucase.md)
* [UNHEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/unhex.md)

***

Modified at: February 6, 2023

Source: [/db/v9.1/reference/sql-reference/string-functions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/)

(An index of the documentation is available at /llms.txt)