# String

- [ABBREVIATE](/latest/user-guide/using/sql-reference/functions/string/abbreviate.md): This page describes the ABBREVIATE function in Lenses SQL.
- [BASE64](/latest/user-guide/using/sql-reference/functions/string/base64.md): This page describes the BASE64function in Lenses SQL.
- [CAPITALIZE](/latest/user-guide/using/sql-reference/functions/string/capitalize.md): This page describes the CAPITALIZE function in Lenses SQL.
- [CENTER](/latest/user-guide/using/sql-reference/functions/string/center.md): This page describes the CENTER function in Lenses SQL.
- [CHOP](/latest/user-guide/using/sql-reference/functions/string/chop.md): This page describes the CHOP function in Lenses SQL.
- [CONCAT](/latest/user-guide/using/sql-reference/functions/string/concat.md): This page describes the CONCAT function in Lenses SQL.
- [CONTAINS](/latest/user-guide/using/sql-reference/functions/string/contains.md): This page describes the CONTAINS function in Lenses SQL.
- [DECODE64](/latest/user-guide/using/sql-reference/functions/string/decode64.md): This page describes the DECODE64 function in Lenses SQL.
- [DELETEWHITESPACE](/latest/user-guide/using/sql-reference/functions/string/deletewhitespace.md): This page describes the DELETEWHITESPACE function in Lenses SQL.
- [DIGITS](/latest/user-guide/using/sql-reference/functions/string/digits.md): This page describes the DIGITS function in Lenses SQL.
- [DROPLEFT](/latest/user-guide/using/sql-reference/functions/string/dropleft.md): This page describes the DROPLEFT function in Lenses SQL.
- [DROPRIGHT](/latest/user-guide/using/sql-reference/functions/string/dropright.md): This page describes the DROPRIGHT function in Lenses SQL.
- [ENDSWITH](/latest/user-guide/using/sql-reference/functions/string/endswith.md): This page describes the ENDSWITH function in Lenses SQL.
- [INDEXOF](/latest/user-guide/using/sql-reference/functions/string/indexof.md): This page describes the INDEXOF function in Lenses SQL.
- [LEN](/latest/user-guide/using/sql-reference/functions/string/len.md): This page describes the LEN function in Lenses SQL.
- [LOWER](/latest/user-guide/using/sql-reference/functions/string/lower.md): This page describes the LOWER  function in Lenses SQL.
- [LPAD](/latest/user-guide/using/sql-reference/functions/string/lpad.md): This page describes the LPAD function in Lenses SQL.
- [MKSTRING](/latest/user-guide/using/sql-reference/functions/string/mkstring.md): This page describes the MKSTRING function in Lenses SQL.
- [REGEXP](/latest/user-guide/using/sql-reference/functions/string/regexp.md): This page describes the REGEXP function in Lenses SQL.
- [REGEX\_MATCHES](/latest/user-guide/using/sql-reference/functions/string/regex_matches.md): This page describes the REGEX\_MATCHES function in Lenses SQL.
- [REPLACE](/latest/user-guide/using/sql-reference/functions/string/replace.md): This page describes the REPLACE function in Lenses SQL.
- [REVERSE](/latest/user-guide/using/sql-reference/functions/string/reverse.md): This page describes the REVERSE function in Lenses SQL.
- [RPAD](/latest/user-guide/using/sql-reference/functions/string/rpad.md): This page describes the REGEX\_MATCHES function in Lenses SQL.
- [STARTSWITH](/latest/user-guide/using/sql-reference/functions/string/startswith.md): This page describes the STARTSWITH function in Lenses SQL.
- [STRIPACCENTS](/latest/user-guide/using/sql-reference/functions/string/stripaccents.md): This page describes the STRIPACCENTS function in Lenses SQL.
- [SUBSTR](/latest/user-guide/using/sql-reference/functions/string/substr.md): This page describes the SUBSTR function in Lenses SQL.
- [SWAPCASE](/latest/user-guide/using/sql-reference/functions/string/swapcase.md): This page describes the SWAPCASE function in Lenses SQL.
- [TAKELEFT](/latest/user-guide/using/sql-reference/functions/string/takeleft.md): This page describes the TAKELEFT function in Lenses SQL.
- [TAKERIGHT](/latest/user-guide/using/sql-reference/functions/string/takeright.md): This page describes the TAKERIGHT function in Lenses SQL.
- [TRIM](/latest/user-guide/using/sql-reference/functions/string/trim.md): This page describes the TRIM function in Lenses SQL.
- [TRUNCATE](/latest/user-guide/using/sql-reference/functions/string/truncate.md): This page describes the TRUNCATE function in Lenses SQL.
- [UNCAPITALIZE](/latest/user-guide/using/sql-reference/functions/string/uncapitalize.md): This page describes the UNCAPITALIZE function in Lenses SQL.
- [UPPER](/latest/user-guide/using/sql-reference/functions/string/upper.md): This page describes the UPPER function in Lenses SQL.
- [UUID](/latest/user-guide/using/sql-reference/functions/string/uuid.md): This page describes the UUID function in Lenses SQL.