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

# String & Binary Functions

## `ascii`

Returns the ascii code of the first character of the string
*Supported Signatures*

```sql theme={null}
function ascii(varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/ascii)

## `base64_decode_binary`

return decoded binary
*Supported Signatures*

```sql theme={null}
function base64_decode_binary(varchar) returns binary
function base64_decode_binary(varchar, varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/base64_decode_binary)

## `base64_decode_string`

return decoded string
*Supported Signatures*

```sql theme={null}
function base64_decode_string(varchar) returns varchar
function base64_decode_string(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/base64_decode_string)

## `base64_encode`

return encoded string
*Supported Signatures*

```sql theme={null}
function base64_encode(varchar) returns varchar
function base64_encode(varchar, decimal(38, 0)) returns varchar
function base64_encode(varchar, decimal(38, 0), varchar) returns varchar
function base64_encode(binary) returns varchar
function base64_encode(binary, decimal(38, 0)) returns varchar
function base64_encode(binary, decimal(38, 0), varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/base64_encode)

## `bit_length`

Returns the length of the object in bits
*Supported Signatures*

```sql theme={null}
function bit_length(varchar) returns decimal(38, 0)
function bit_length(binary) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bit_length)

## `char`

Convert an ASCII or Unicode code into a single character
*Supported Signatures*

```sql theme={null}
function char(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/char)

## `charindex`

Returns the position of the needle in the haystack, optionally from a given index
*Supported Signatures*

```sql theme={null}
function charindex(varchar, varchar) returns decimal(38, 0)
function charindex(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function charindex(binary, binary) returns decimal(38, 0)
function charindex(binary, binary, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/charindex)

## `chr`

Convert an ASCII or Unicode code into a single character
*Supported Signatures*

```sql theme={null}
function chr(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/chr)

## `collate`

*Supported Signatures*

```sql theme={null}
function collate($1, string) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/collate)

## `collation`

*Supported Signatures*

```sql theme={null}
function collation($1) returns string
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/collation)

## `compress`

compressed data (return)
*Supported Signatures*

```sql theme={null}
function compress(varchar, varchar) returns binary
function compress(binary, varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/compress)

## `concat`

Returns concatenation of the input strings, or null if any one of them is null.
*Supported Signatures*

```sql theme={null}
function concat(varchar, ...) returns varchar
function concat(binary, ...) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/concat)

## `concat_ws`

Returns concatenation of the input strings with separator, or null if any one of them is null.
*Supported Signatures*

```sql theme={null}
function concat_ws(varchar, varchar, ...) returns varchar
function concat_ws(binary, binary, ...) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/concat_ws)

## `contains`

returns TRUE if arg1 constains arg2
*Supported Signatures*

```sql theme={null}
function contains(varchar, varchar) returns boolean
function contains(binary, binary) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/contains)

## `decompress_binary`

decompressed binary (return)
*Supported Signatures*

```sql theme={null}
function decompress_binary(binary, varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/decompress_binary)

## `decompress_string`

decompressed string (return)
*Supported Signatures*

```sql theme={null}
function decompress_string(binary, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/decompress_string)

## `editdistance`

Returns the Levenshtein edit distance between two strings.
*Supported Signatures*

```sql theme={null}
function editdistance(varchar, varchar) returns decimal(38, 0)
function editdistance(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/editdistance)

## `endswith`

returns TRUE if arg1 ends with arg2
*Supported Signatures*

```sql theme={null}
function endswith(varchar, varchar) returns boolean
function endswith(binary, binary) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/endswith)

## `hex_decode_binary`

return decoded binary
*Supported Signatures*

```sql theme={null}
function hex_decode_binary(varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hex_decode_binary)

## `hex_decode_string`

return decoded string
*Supported Signatures*

```sql theme={null}
function hex_decode_string(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hex_decode_string)

## `hex_encode`

return encoded string
*Supported Signatures*

```sql theme={null}
function hex_encode(varchar) returns varchar
function hex_encode(varchar, decimal(38, 0)) returns varchar
function hex_encode(binary) returns varchar
function hex_encode(binary, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hex_encode)

## `initcap`

return string with all the initial letter of each word is LOWERcase.
*Supported Signatures*

```sql theme={null}
function initcap(varchar) returns varchar
function initcap(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/initcap)

## `insert`

Returns the first string with a substring at the given position and length replaced with the second string
*Supported Signatures*

```sql theme={null}
function insert(varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/insert)

## `jarowinkler_similarity`

Returns the Jaro-Winkler similarity metric between two strings.
*Supported Signatures*

```sql theme={null}
function jarowinkler_similarity(varchar, varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/jarowinkler_similarity)

## `left`

Returns leftmost N characters of the input string
*Supported Signatures*

```sql theme={null}
function left(varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/left)

## `len`

Returns length of string
*Supported Signatures*

```sql theme={null}
function len(varchar) returns decimal(38, 0)
function len(binary) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/len)

## `length`

Returns the length of the string
*Supported Signatures*

```sql theme={null}
function length(varchar) returns decimal(18, 0)
function length(binary) returns decimal(18, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/length)

## `lower`

return string with all characters in lowercase
*Supported Signatures*

```sql theme={null}
function lower(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/lower)

## `lpad`

padded result string
*Supported Signatures*

```sql theme={null}
function lpad(varchar, decimal(38, 0)) returns varchar
function lpad(varchar, decimal(38, 0), varchar) returns varchar
function lpad(binary, decimal(38, 0), binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/lpad)

## `ltrim`

return string trimmed from left
*Supported Signatures*

```sql theme={null}
function ltrim(varchar) returns varchar
function ltrim(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/ltrim)

## `md5`

Hex-encoded MD5 digest
*Supported Signatures*

```sql theme={null}
function md5(varchar) returns varchar
function md5(binary) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/md5)

## `md5_binary`

Binary MD5 digest
*Supported Signatures*

```sql theme={null}
function md5_binary(varchar) returns binary
function md5_binary(binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/md5_binary)

## `md5_hex`

Hex-encoded MD5 digest
*Supported Signatures*

```sql theme={null}
function md5_hex(varchar) returns varchar
function md5_hex(binary) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/md5_hex)

## `md5_number_lower64`

*Supported Signatures*

```sql theme={null}
function md5_number_lower64(string) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/md5_number_lower64)

## `md5_number_upper64`

*Supported Signatures*

```sql theme={null}
function md5_number_upper64(string) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/md5_number_upper64)

## `octet_length`

Returns the length of the string in bytes
*Supported Signatures*

```sql theme={null}
function octet_length(varchar) returns decimal(38, 0)
function octet_length(binary) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/octet_length)

## `parse_ip`

Returns an object with all the components of the IP
*Supported Signatures*

```sql theme={null}
function parse_ip(varchar, varchar) returns object
function parse_ip(varchar, varchar, decimal(38, 0)) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/parse_ip)

## `parse_url`

Returns an object with all the components of the URL
*Supported Signatures*

```sql theme={null}
function parse_url(varchar) returns object
function parse_url(varchar, decimal(38, 0)) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/parse_url)

## `position`

Returns the position of the needle in the haystack, optionally from a given index
*Supported Signatures*

```sql theme={null}
function position(varchar, varchar) returns decimal(38, 0)
function position(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function position(binary, binary) returns decimal(38, 0)
function position(binary, binary, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/position)

## `repeat`

Returns the input string repeated N times
*Supported Signatures*

```sql theme={null}
function repeat(varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/repeat)

## `replace`

replaces all occurrences of searched substring in subject with a replacement
*Supported Signatures*

```sql theme={null}
function replace(varchar, varchar) returns varchar
function replace(varchar, varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/replace)

## `reverse`

return string with character order reversed
*Supported Signatures*

```sql theme={null}
function reverse(varchar) returns varchar
function reverse(binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/reverse)

## `right`

Returns rightmost N characters of the input string
*Supported Signatures*

```sql theme={null}
function right(varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/right)

## `rpad`

padded result string
*Supported Signatures*

```sql theme={null}
function rpad(varchar, decimal(38, 0)) returns varchar
function rpad(varchar, decimal(38, 0), varchar) returns varchar
function rpad(binary, decimal(38, 0), binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/rpad)

## `rtrim`

return string trimmed from right
*Supported Signatures*

```sql theme={null}
function rtrim(varchar) returns varchar
function rtrim(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/rtrim)

## `rtrimmed_length`

Returns the length of the input string without trailing blanks
*Supported Signatures*

```sql theme={null}
function rtrimmed_length(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/rtrimmed_length)

## `sha1`

Hex-encoded SHA1 digest
*Supported Signatures*

```sql theme={null}
function sha1(varchar) returns varchar
function sha1(binary) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha1)

## `sha1_binary`

Binary SHA1 digest
*Supported Signatures*

```sql theme={null}
function sha1_binary(varchar) returns binary
function sha1_binary(binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha1_binary)

## `sha1_hex`

Hex-encoded SHA1 digest
*Supported Signatures*

```sql theme={null}
function sha1_hex(varchar) returns varchar
function sha1_hex(binary) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha1_hex)

## `sha2`

Hex-encoded SHA2 digest
*Supported Signatures*

```sql theme={null}
function sha2(varchar) returns varchar
function sha2(varchar, decimal(38, 0)) returns varchar
function sha2(binary) returns varchar
function sha2(binary, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha2)

## `sha2_binary`

Binary SHA2 digest
*Supported Signatures*

```sql theme={null}
function sha2_binary(varchar) returns binary
function sha2_binary(varchar, decimal(38, 0)) returns binary
function sha2_binary(binary) returns binary
function sha2_binary(binary, decimal(38, 0)) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha2_binary)

## `sha2_hex`

Hex-encoded SHA2 digest
*Supported Signatures*

```sql theme={null}
function sha2_hex(varchar) returns varchar
function sha2_hex(varchar, decimal(38, 0)) returns varchar
function sha2_hex(binary) returns varchar
function sha2_hex(binary, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sha2_hex)

## `soundex`

soundex encoding of string
*Supported Signatures*

```sql theme={null}
function soundex(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/soundex)

## `soundex_p123`

soundex\_p123 encoding of string
*Supported Signatures*

```sql theme={null}
function soundex_p123(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/soundex_p123)

## `space`

N spaces
*Supported Signatures*

```sql theme={null}
function space(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/space)

## `split`

return split string as array
*Supported Signatures*

```sql theme={null}
function split(varchar, varchar) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/split)

## `split_part`

Splits a string with a delimiter and returns the requested part
*Supported Signatures*

```sql theme={null}
function split_part(varchar, varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/split_part)

## `split_to_table`

*Supported Signatures*

```sql theme={null}
function split_to_table(string, string) returns struct<seq int, index int, value string>
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/split_to_table)

## `startswith`

returns TRUE if arg1 starts with arg2
*Supported Signatures*

```sql theme={null}
function startswith(varchar, varchar) returns boolean
function startswith(binary, binary) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/startswith)

## `strtok`

Tokenizes a string with a delimiter and returns the requested part
*Supported Signatures*

```sql theme={null}
function strtok(varchar) returns varchar
function strtok(varchar, varchar) returns varchar
function strtok(varchar, varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/strtok)

## `strtok_split_to_table`

*Supported Signatures*

```sql theme={null}
function strtok_split_to_table(string, ...) returns struct<seq int, index int, value string>
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/strtok_split_to_table)

## `strtok_to_array`

Return tokenized string as array
*Supported Signatures*

```sql theme={null}
function strtok_to_array(varchar) returns array
function strtok_to_array(varchar, varchar) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/strtok_to_array)

## `substr`

Returns string fragment of the input string
*Supported Signatures*

```sql theme={null}
function substr(varchar, decimal(38, 0)) returns varchar
function substr(varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function substr(binary, decimal(38, 0)) returns binary
function substr(binary, decimal(38, 0), decimal(38, 0)) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/substr)

## `substring`

Returns string fragment of the input string
*Supported Signatures*

```sql theme={null}
function substring(varchar, decimal(38, 0)) returns varchar
function substring(varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function substring(binary, decimal(38, 0)) returns binary
function substring(binary, decimal(38, 0), decimal(38, 0)) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/substring)

## `translate`

replaces all occurences of each character of the source alphabet in the subject with the corresponding character in the target alphabet
*Supported Signatures*

```sql theme={null}
function translate(varchar, varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/translate)

## `trim`

return string trimmed from both sides
*Supported Signatures*

```sql theme={null}
function trim(varchar) returns varchar
function trim(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/trim)

## `try_base64_decode_binary`

return decoded binary
*Supported Signatures*

```sql theme={null}
function try_base64_decode_binary(varchar) returns binary
function try_base64_decode_binary(varchar, varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_base64_decode_binary)

## `try_base64_decode_string`

return decoded string
*Supported Signatures*

```sql theme={null}
function try_base64_decode_string(varchar) returns varchar
function try_base64_decode_string(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_base64_decode_string)

## `try_hex_decode_binary`

return decoded binary
*Supported Signatures*

```sql theme={null}
function try_hex_decode_binary(varchar) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_hex_decode_binary)

## `try_hex_decode_string`

return decoded string
*Supported Signatures*

```sql theme={null}
function try_hex_decode_string(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_hex_decode_string)

## `unicode`

Returns the Unicode code point of the first character of the string
*Supported Signatures*

```sql theme={null}
function unicode(varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/unicode)

## `upper`

return string with all characters in uppercase
*Supported Signatures*

```sql theme={null}
function upper(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/upper)

## `uuid_string`

Returns a pseudo-randomly generated (version 4) UUID.
*Supported Signatures*

```sql theme={null}
function uuid_string() returns varchar
function uuid_string(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/uuid_string)