String & Binary Functions
ascii
Returns the ascii code of the first character of the string Supported Signatures
function ascii(varchar) returns decimal(38, 0)
base64_decode_binary
return decoded binary Supported Signatures
function base64_decode_binary(varchar) returns binary
function base64_decode_binary(varchar, varchar) returns binary
base64_decode_string
return decoded string Supported Signatures
function base64_decode_string(varchar) returns varchar
function base64_decode_string(varchar, varchar) returns varchar
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
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)
char
Convert an ASCII or Unicode code into a single character Supported Signatures
function char(decimal(38, 0)) returns varchar
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)
chr
Convert an ASCII or Unicode code into a single character Supported Signatures
function chr(decimal(38, 0)) returns varchar
collate
Supported Signatures
function collate($1, string) returns $1
collation
Supported Signatures
function collation($1) returns string
compress
compressed data (return) Supported Signatures
function compress(varchar, varchar) returns binary
function compress(binary, varchar) returns binary
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
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
contains
returns TRUE if arg1 constains arg2 Supported Signatures
function contains(varchar, varchar) returns boolean
function contains(binary, binary) returns boolean
decompress_binary
decompressed binary (return) Supported Signatures
function decompress_binary(binary, varchar) returns binary
decompress_string
decompressed string (return) Supported Signatures
function decompress_string(binary, varchar) returns varchar
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)
endswith
returns TRUE if arg1 ends with arg2 Supported Signatures
function endswith(varchar, varchar) returns boolean
function endswith(binary, binary) returns boolean
hex_decode_binary
return decoded binary Supported Signatures
function hex_decode_binary(varchar) returns binary
hex_decode_string
return decoded string Supported Signatures
function hex_decode_string(varchar) returns varchar
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
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
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
jarowinkler_similarity
Returns the Jaro-Winkler similarity metric between two strings. Supported Signatures
function jarowinkler_similarity(varchar, varchar) returns decimal(38, 0)
left
Returns leftmost N characters of the input string Supported Signatures
function left(varchar, decimal(38, 0)) returns varchar
len
Returns length of string Supported Signatures
function len(varchar) returns decimal(38, 0)
function len(binary) returns decimal(38, 0)
length
Returns the length of the string Supported Signatures
function length(varchar) returns decimal(38, 0)
function length(binary) returns decimal(38, 0)
lower
return string with all characters in lowercase Supported Signatures
function lower(varchar) returns varchar
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
ltrim
return string trimmed from left Supported Signatures
function ltrim(varchar) returns varchar
function ltrim(varchar, varchar) returns varchar
md5
Hex-encoded MD5 digest Supported Signatures
function md5(varchar) returns varchar
function md5(binary) returns varchar
md5_binary
Binary MD5 digest Supported Signatures
function md5_binary(varchar) returns binary
function md5_binary(binary) returns binary
md5_hex
Hex-encoded MD5 digest Supported Signatures
function md5_hex(varchar) returns varchar
function md5_hex(binary) returns varchar
md5_number_lower64
Supported Signatures
function md5_number_lower64(string) returns binary
md5_number_upper64
Supported Signatures
function md5_number_upper64(string) returns binary
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)
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
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
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)
repeat
Returns the input string repeated N times Supported Signatures
function repeat(varchar, decimal(38, 0)) returns varchar
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
reverse
return string with character order reversed Supported Signatures
function reverse(varchar) returns varchar
function reverse(binary) returns binary
right
Returns rightmost N characters of the input string Supported Signatures
function right(varchar, decimal(38, 0)) returns varchar
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
rtrim
return string trimmed from right Supported Signatures
function rtrim(varchar) returns varchar
function rtrim(varchar, varchar) returns varchar
rtrimmed_length
Returns the length of the input string without trailing blanks Supported Signatures
function rtrimmed_length(varchar) returns varchar
sha1
Hex-encoded SHA1 digest Supported Signatures
function sha1(varchar) returns varchar
function sha1(binary) returns varchar
sha1_binary
Binary SHA1 digest Supported Signatures
function sha1_binary(varchar) returns binary
function sha1_binary(binary) returns binary
sha1_hex
Hex-encoded SHA1 digest Supported Signatures
function sha1_hex(varchar) returns varchar
function sha1_hex(binary) returns varchar
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
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
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
soundex
soundex encoding of string Supported Signatures
function soundex(varchar) returns varchar
soundex_p123
soundex_p123 encoding of string Supported Signatures
function soundex_p123(varchar) returns varchar
space
N spaces Supported Signatures
function space(decimal(38, 0)) returns varchar
split
return split string as array Supported Signatures
function split(varchar, varchar) returns array
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
split_to_table
Supported Signatures
function split_to_table(string, string) returns struct<seq int, index int, value string>
startswith
returns TRUE if arg1 starts with arg2 Supported Signatures
function startswith(varchar, varchar) returns boolean
function startswith(binary, binary) returns boolean
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
strtok_split_to_table
Supported Signatures
function strtok_split_to_table(string, ...) returns struct<seq int, index int, value string>
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
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
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
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
trim
return string trimmed from both sides Supported Signatures
function trim(varchar) returns varchar
function trim(varchar, varchar) returns varchar
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
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
try_hex_decode_binary
return decoded binary Supported Signatures
function try_hex_decode_binary(varchar) returns binary
try_hex_decode_string
return decoded string Supported Signatures
function try_hex_decode_string(varchar) returns varchar
unicode
Returns the Unicode code point of the first character of the string Supported Signatures
function unicode(varchar) returns decimal(38, 0)
upper
return string with all characters in uppercase Supported Signatures
function upper(varchar) returns varchar
uuid_string
Returns a pseudo-randomly generated (version 4) UUID. Supported Signatures
function uuid_string() returns varchar
function uuid_string(varchar, varchar) returns varchar