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