String & Binary Functions

`ascii`

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

function ascii(varchar) returns decimal(38, 0)

🔗 Official Documentation

`base64_decode_binary`

return decoded binary Supported Signatures

function base64_decode_binary(varchar) returns binary
function base64_decode_binary(varchar, varchar) returns binary

🔗 Official Documentation

`base64_decode_string`

return decoded string Supported Signatures

function base64_decode_string(varchar) returns varchar
function base64_decode_string(varchar, varchar) returns varchar

🔗 Official Documentation

`base64_encode`

return encoded string Supported Signatures

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

`bit_length`

Returns the length of the object in bits Supported Signatures

function bit_length(varchar) returns decimal(38, 0)
function bit_length(binary) returns decimal(38, 0)

🔗 Official Documentation

`char`

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

function char(decimal(38, 0)) returns varchar

🔗 Official Documentation

`charindex`

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

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

`chr`

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

function chr(decimal(38, 0)) returns varchar

🔗 Official Documentation

`collate`

Supported Signatures

function collate($1, string) returns $1

🔗 Official Documentation

`collation`

Supported Signatures

function collation($1) returns string

🔗 Official Documentation

`compress`

compressed data (return) Supported Signatures

function compress(varchar, varchar) returns binary
function compress(binary, varchar) returns binary

🔗 Official Documentation

`concat`

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

function concat(varchar, ...) returns varchar
function concat(binary, ...) returns binary

🔗 Official Documentation

`concat_ws`

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

function concat_ws(varchar, varchar, ...) returns varchar
function concat_ws(binary, binary, ...) returns binary

🔗 Official Documentation

`contains`

returns TRUE if arg1 constains arg2 Supported Signatures

function contains(varchar, varchar) returns boolean
function contains(binary, binary) returns boolean

🔗 Official Documentation

`decompress_binary`

decompressed binary (return) Supported Signatures

function decompress_binary(binary, varchar) returns binary

🔗 Official Documentation

`decompress_string`

decompressed string (return) Supported Signatures

function decompress_string(binary, varchar) returns varchar

🔗 Official Documentation

`editdistance`

Returns the Levenshtein edit distance between two strings. Supported Signatures

function editdistance(varchar, varchar) returns decimal(38, 0)
function editdistance(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

`endswith`

returns TRUE if arg1 ends with arg2 Supported Signatures

function endswith(varchar, varchar) returns boolean
function endswith(binary, binary) returns boolean

🔗 Official Documentation

`hex_decode_binary`

return decoded binary Supported Signatures

function hex_decode_binary(varchar) returns binary

🔗 Official Documentation

`hex_decode_string`

return decoded string Supported Signatures

function hex_decode_string(varchar) returns varchar

🔗 Official Documentation

`hex_encode`

return encoded string Supported Signatures

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

`initcap`

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

function initcap(varchar) returns varchar
function initcap(varchar, varchar) returns varchar

🔗 Official Documentation

`insert`

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

function insert(varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar

🔗 Official Documentation

`jarowinkler_similarity`

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

function jarowinkler_similarity(varchar, varchar) returns decimal(38, 0)

🔗 Official Documentation

`left`

Returns leftmost N characters of the input string Supported Signatures

function left(varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

`len`

Returns length of string Supported Signatures

function len(varchar) returns decimal(38, 0)
function len(binary) returns decimal(38, 0)

🔗 Official Documentation

`length`

Returns the length of the string Supported Signatures

function length(varchar) returns decimal(18, 0)
function length(binary) returns decimal(18, 0)

🔗 Official Documentation

`lower`

return string with all characters in lowercase Supported Signatures

function lower(varchar) returns varchar

🔗 Official Documentation

`lpad`

padded result string Supported Signatures

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

`ltrim`

return string trimmed from left Supported Signatures

function ltrim(varchar) returns varchar
function ltrim(varchar, varchar) returns varchar

🔗 Official Documentation

`md5`

Hex-encoded MD5 digest Supported Signatures

function md5(varchar) returns varchar
function md5(binary) returns varchar

🔗 Official Documentation

`md5_binary`

Binary MD5 digest Supported Signatures

function md5_binary(varchar) returns binary
function md5_binary(binary) returns binary

🔗 Official Documentation

`md5_hex`

Hex-encoded MD5 digest Supported Signatures

function md5_hex(varchar) returns varchar
function md5_hex(binary) returns varchar

🔗 Official Documentation

`md5_number_lower64`

Supported Signatures

function md5_number_lower64(string) returns binary

🔗 Official Documentation

`md5_number_upper64`

Supported Signatures

function md5_number_upper64(string) returns binary

🔗 Official Documentation

`octet_length`

Returns the length of the string in bytes Supported Signatures

function octet_length(varchar) returns decimal(38, 0)
function octet_length(binary) returns decimal(38, 0)

🔗 Official Documentation

`parse_ip`

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

function parse_ip(varchar, varchar) returns object
function parse_ip(varchar, varchar, decimal(38, 0)) returns object

🔗 Official Documentation

`parse_url`

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

function parse_url(varchar) returns object
function parse_url(varchar, decimal(38, 0)) returns object

🔗 Official Documentation

`position`

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

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

`repeat`

Returns the input string repeated N times Supported Signatures

function repeat(varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

`replace`

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

function replace(varchar, varchar) returns varchar
function replace(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

`reverse`

return string with character order reversed Supported Signatures

function reverse(varchar) returns varchar
function reverse(binary) returns binary

🔗 Official Documentation

`right`

Returns rightmost N characters of the input string Supported Signatures

function right(varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

`rpad`

padded result string Supported Signatures

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

`rtrim`

return string trimmed from right Supported Signatures

function rtrim(varchar) returns varchar
function rtrim(varchar, varchar) returns varchar

🔗 Official Documentation

`rtrimmed_length`

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

function rtrimmed_length(varchar) returns varchar

🔗 Official Documentation

`sha1`

Hex-encoded SHA1 digest Supported Signatures

function sha1(varchar) returns varchar
function sha1(binary) returns varchar

🔗 Official Documentation

`sha1_binary`

Binary SHA1 digest Supported Signatures

function sha1_binary(varchar) returns binary
function sha1_binary(binary) returns binary

🔗 Official Documentation

`sha1_hex`

Hex-encoded SHA1 digest Supported Signatures

function sha1_hex(varchar) returns varchar
function sha1_hex(binary) returns varchar

🔗 Official Documentation

`sha2`

Hex-encoded SHA2 digest Supported Signatures

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

`sha2_binary`

Binary SHA2 digest Supported Signatures

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

`sha2_hex`

Hex-encoded SHA2 digest Supported Signatures

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

`soundex`

soundex encoding of string Supported Signatures

function soundex(varchar) returns varchar

🔗 Official Documentation

`soundex_p123`

soundex_p123 encoding of string Supported Signatures

function soundex_p123(varchar) returns varchar

🔗 Official Documentation

`space`

N spaces Supported Signatures

function space(decimal(38, 0)) returns varchar

🔗 Official Documentation

`split`

return split string as array Supported Signatures

function split(varchar, varchar) returns array

🔗 Official Documentation

`split_part`

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

function split_part(varchar, varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

`split_to_table`

Supported Signatures

function split_to_table(string, string) returns struct<seq int, index int, value string>

🔗 Official Documentation

`startswith`

returns TRUE if arg1 starts with arg2 Supported Signatures

function startswith(varchar, varchar) returns boolean
function startswith(binary, binary) returns boolean

🔗 Official Documentation

`strtok`

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

function strtok(varchar) returns varchar
function strtok(varchar, varchar) returns varchar
function strtok(varchar, varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

`strtok_split_to_table`

Supported Signatures

function strtok_split_to_table(string, ...) returns struct<seq int, index int, value string>

🔗 Official Documentation

`strtok_to_array`

Return tokenized string as array Supported Signatures

function strtok_to_array(varchar) returns array
function strtok_to_array(varchar, varchar) returns array

🔗 Official Documentation

`substr`

Returns string fragment of the input string Supported Signatures

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

`substring`

Returns string fragment of the input string Supported Signatures

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

`translate`

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

function translate(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

`trim`

return string trimmed from both sides Supported Signatures

function trim(varchar) returns varchar
function trim(varchar, varchar) returns varchar

🔗 Official Documentation

`try_base64_decode_binary`

return decoded binary Supported Signatures

function try_base64_decode_binary(varchar) returns binary
function try_base64_decode_binary(varchar, varchar) returns binary

🔗 Official Documentation

`try_base64_decode_string`

return decoded string Supported Signatures

function try_base64_decode_string(varchar) returns varchar
function try_base64_decode_string(varchar, varchar) returns varchar

🔗 Official Documentation

`try_hex_decode_binary`

return decoded binary Supported Signatures

function try_hex_decode_binary(varchar) returns binary

🔗 Official Documentation

`try_hex_decode_string`

return decoded string Supported Signatures

function try_hex_decode_string(varchar) returns varchar

🔗 Official Documentation

`unicode`

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

function unicode(varchar) returns decimal(38, 0)

🔗 Official Documentation

`upper`

return string with all characters in uppercase Supported Signatures

function upper(varchar) returns varchar

🔗 Official Documentation

`uuid_string`

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

function uuid_string() returns varchar
function uuid_string(varchar, varchar) returns varchar

🔗 Official Documentation

Reference

SQL Functions

​ascii

​base64_decode_binary

​base64_decode_string

​base64_encode

​bit_length

​char

​charindex

​chr

​collate

​collation

​compress

​concat

​concat_ws

​contains

​decompress_binary

​decompress_string

​editdistance

​endswith

​hex_decode_binary

​hex_decode_string

​hex_encode

​initcap

​insert

​jarowinkler_similarity

​left

​len

​length

​lower

​lpad

​ltrim

​md5

​md5_binary

​md5_hex

​md5_number_lower64

​md5_number_upper64

​octet_length

​parse_ip

​parse_url

​position

​repeat

​replace

​reverse

​right

​rpad

​rtrim

​rtrimmed_length

​sha1

​sha1_binary

​sha1_hex

​sha2

​sha2_binary

​sha2_hex

​soundex

​soundex_p123

​space

​split

​split_part

​split_to_table

​startswith

​strtok

​strtok_split_to_table

​strtok_to_array

​substr

​substring

​translate

​trim

​try_base64_decode_binary

​try_base64_decode_string

​try_hex_decode_binary

​try_hex_decode_string

​unicode

​upper

​uuid_string

`ascii`

`base64_decode_binary`

`base64_decode_string`

`base64_encode`

`bit_length`

`char`

`charindex`

`chr`

`collate`

`collation`

`compress`

`concat`

`concat_ws`

`contains`

`decompress_binary`

`decompress_string`

`editdistance`

`endswith`

`hex_decode_binary`

`hex_decode_string`

`hex_encode`

`initcap`

`insert`

`jarowinkler_similarity`

`left`

`len`

`length`

`lower`

`lpad`

`ltrim`

`md5`

`md5_binary`

`md5_hex`

`md5_number_lower64`

`md5_number_upper64`

`octet_length`

`parse_ip`

`parse_url`

`position`

`repeat`

`replace`

`reverse`

`right`

`rpad`

`rtrim`

`rtrimmed_length`

`sha1`

`sha1_binary`

`sha1_hex`

`sha2`

`sha2_binary`

`sha2_hex`

`soundex`

`soundex_p123`

`space`

`split`

`split_part`

`split_to_table`

`startswith`

`strtok`

`strtok_split_to_table`

`strtok_to_array`

`substr`

`substring`

`translate`

`trim`

`try_base64_decode_binary`

`try_base64_decode_string`

`try_hex_decode_binary`

`try_hex_decode_string`

`unicode`

`upper`

`uuid_string`