> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# String functions

> Search, slice, combine, pad, format and transform text.

Search, slice, combine, pad, format and transform text.

| Function | Type | What it does |
| - | - | - |
| [`ascii`](https://docs.e6data.com/query/sql/functions/string/ascii) | Scalar | Returns the Unicode code point of the first character in a string. |
| [`base64`](https://docs.e6data.com/query/sql/functions/string/base64) | Scalar | Encodes bytes as MIME Base64 text. |
| [`char`](https://docs.e6data.com/query/sql/functions/string/char) | Scalar | Returns the character for the low eight bits of a nonnegative numeric value. |
| [`char_length`](https://docs.e6data.com/query/sql/functions/string/char_length) | Scalar | Counts Unicode characters in a string. |
| [`character_length`](https://docs.e6data.com/query/sql/functions/string/character_length) | Scalar | Counts Unicode characters in a string. |
| [`charindex`](https://docs.e6data.com/query/sql/functions/string/charindex) | Scalar | Returns a substring position. |
| [`chr`](https://docs.e6data.com/query/sql/functions/string/chr) | Scalar | Returns the character for the low eight bits of a nonnegative numeric value. |
| [`concat`](https://docs.e6data.com/query/sql/functions/string/concat) | Scalar | Concatenates strings in argument order. |
| [`concat_ws`](https://docs.e6data.com/query/sql/functions/string/concat_ws) | Scalar | Joins strings or string-array elements using a separator. |
| [`contains_substr`](https://docs.e6data.com/query/sql/functions/string/contains_substr) | Scalar | Tests whether a string contains another string. |
| [`encode`](https://docs.e6data.com/query/sql/functions/string/encode) | Scalar | Encodes text using a character encoding. |
| [`ends_with`](https://docs.e6data.com/query/sql/functions/string/ends_with) | Scalar | Tests whether a string ends with another string. |
| [`endswith`](https://docs.e6data.com/query/sql/functions/string/endswith) | Scalar | Tests whether a string ends with another string. |
| [`format`](https://docs.e6data.com/query/sql/functions/string/format) | Scalar | Formats values using a printf-style pattern. |
| [`format_number`](https://docs.e6data.com/query/sql/functions/string/format_number) | Scalar | Formats a number using digits or a decimal pattern. |
| [`format_string`](https://docs.e6data.com/query/sql/functions/string/format_string) | Scalar | Formats values using a printf-style pattern. |
| [`from_base64`](https://docs.e6data.com/query/sql/functions/string/from_base64) | Scalar | Decodes MIME Base64 text. |
| [`ilike`](https://docs.e6data.com/query/sql/functions/string/ilike) | Scalar | Tests whether a string matches a SQL wildcard pattern without case sensitivity. |
| [`initcap`](https://docs.e6data.com/query/sql/functions/string/initcap) | Scalar | Capitalizes each word and lowercases the rest. |
| [`instr`](https://docs.e6data.com/query/sql/functions/string/instr) | Scalar | Returns a substring position. |
| [`lcase`](https://docs.e6data.com/query/sql/functions/string/lcase) | Scalar | Converts a string to lowercase. |
| [`left`](https://docs.e6data.com/query/sql/functions/string/left) | Scalar | Returns characters from the start of a string. |
| [`len`](https://docs.e6data.com/query/sql/functions/string/len) | Scalar | Returns the number of Unicode characters in a string. |
| [`length`](https://docs.e6data.com/query/sql/functions/string/length) | Scalar | Returns the character count of a string or the byte count of binary data. |
| [`levenshtein`](https://docs.e6data.com/query/sql/functions/string/levenshtein) | Scalar | Counts the edits needed to transform one string into another. |
| [`like`](https://docs.e6data.com/query/sql/functions/string/like) | Scalar | Tests whether a string matches a SQL wildcard pattern. |
| [`locate`](https://docs.e6data.com/query/sql/functions/string/locate) | Scalar | Returns a substring position. |
| [`lower`](https://docs.e6data.com/query/sql/functions/string/lower) | Scalar | Converts a string to lowercase. |
| [`lower_case`](https://docs.e6data.com/query/sql/functions/string/lower_case) | Scalar | Converts a string to lowercase. |
| [`lpad`](https://docs.e6data.com/query/sql/functions/string/lpad) | Scalar | Pads or truncates a string to a requested character length. |
| [`ltrim`](https://docs.e6data.com/query/sql/functions/string/ltrim) | Scalar | Removes leading characters from a string. |
| [`mid`](https://docs.e6data.com/query/sql/functions/string/mid) | Scalar | Extracts part of a string or binary value. |
| [`octet_length`](https://docs.e6data.com/query/sql/functions/string/octet_length) | Scalar | Counts the bytes in a string or binary value. |
| [`overlay`](https://docs.e6data.com/query/sql/functions/string/overlay) | Scalar | Replaces a span of string characters with another string. |
| [`parse_url`](https://docs.e6data.com/query/sql/functions/string/parse_url) | Scalar | Extracts a component or query parameter from a URL string. |
| [`position`](https://docs.e6data.com/query/sql/functions/string/position) | Scalar | Returns a substring position. |
| [`repeat`](https://docs.e6data.com/query/sql/functions/string/repeat) | Scalar | Repeats a string a specified number of times. |
| [`replace`](https://docs.e6data.com/query/sql/functions/string/replace) | Scalar | Replaces all literal occurrences of a substring. |
| [`reverse`](https://docs.e6data.com/query/sql/functions/string/reverse) | Scalar | Reverses the characters in a string or the elements in an array. |
| [`right`](https://docs.e6data.com/query/sql/functions/string/right) | Scalar | Returns characters from the end of a string. |
| [`rpad`](https://docs.e6data.com/query/sql/functions/string/rpad) | Scalar | Pads or truncates a string to a requested character length. |
| [`rtrim`](https://docs.e6data.com/query/sql/functions/string/rtrim) | Scalar | Removes trailing characters from a string. |
| [`soundex`](https://docs.e6data.com/query/sql/functions/string/soundex) | Being confirmed | Previous docs; being confirmed. |
| [`split`](https://docs.e6data.com/query/sql/functions/string/split) | Scalar | Splits a string on a regular-expression delimiter. |
| [`split_part`](https://docs.e6data.com/query/sql/functions/string/split_part) | Scalar | Returns a selected substring after splitting a string on a literal delimiter. |
| [`starts_with`](https://docs.e6data.com/query/sql/functions/string/starts_with) | Scalar | Tests whether a string starts with another string. |
| [`startswith`](https://docs.e6data.com/query/sql/functions/string/startswith) | Scalar | Tests whether a string starts with another string. |
| [`strpos`](https://docs.e6data.com/query/sql/functions/string/strpos) | Scalar | Returns a substring position. |
| [`substr`](https://docs.e6data.com/query/sql/functions/string/substr) | Scalar | Extracts part of a string or binary value. |
| [`substring`](https://docs.e6data.com/query/sql/functions/string/substring) | Scalar | Extracts part of a string or binary value. |
| [`substring_index`](https://docs.e6data.com/query/sql/functions/string/substring_index) | Scalar | Returns a prefix or suffix selected by delimiter occurrence count. |
| [`to_base64`](https://docs.e6data.com/query/sql/functions/string/to_base64) | Scalar | Encodes bytes as MIME Base64 text. |
| [`to_hex`](https://docs.e6data.com/query/sql/functions/string/to_hex) | Scalar | Returns uppercase hexadecimal text. |
| [`translate`](https://docs.e6data.com/query/sql/functions/string/translate) | Scalar | Replaces or removes individual characters according to corresponding character lists. |
| [`trim`](https://docs.e6data.com/query/sql/functions/string/trim) | Scalar | Removes characters from the beginning, end or both ends of a string. |
| [`try_url_decode`](https://docs.e6data.com/query/sql/functions/string/try_url_decode) | Scalar | Decodes form URL encoding, returning NULL for invalid input. |
| [`ucase`](https://docs.e6data.com/query/sql/functions/string/ucase) | Scalar | Converts a string to uppercase. |
| [`unbase64`](https://docs.e6data.com/query/sql/functions/string/unbase64) | Scalar | Decodes MIME Base64 text. |
| [`upper`](https://docs.e6data.com/query/sql/functions/string/upper) | Scalar | Converts a string to uppercase. |
| [`upper_case`](https://docs.e6data.com/query/sql/functions/string/upper_case) | Scalar | Converts a string to uppercase. |
| [`url_decode`](https://docs.e6data.com/query/sql/functions/string/url_decode) | Scalar | Decodes form URL encoding into a UTF-8 string. |
| [`url_encode`](https://docs.e6data.com/query/sql/functions/string/url_encode) | Scalar | Encodes a string using application/x-www-form-urlencoded rules. |
| [`uuid`](https://docs.e6data.com/query/sql/functions/string/uuid) | Scalar | Returns a randomly generated UUID version 4 string. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.