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
