String Functions

​

chr

Returns the Unicode code point n as a single character string.

Examples:

select chr(61) as value; -- value '='

Supported Signatures

function chr(bigint) returns varchar

🔗 Official Documentation

​

codepoint

Returns the Unicode code point of the only character of string.

Examples:

SELECT codepoint('😊') AS value; -- value '128522'

Supported Signatures

function codepoint(varchar) returns bigint

🔗 Official Documentation

​

concat

Returns the concatenation of string1, string2, …, stringN. This function provides the same functionality as the SQL-standard concatenation operator (||).

Examples:

select concat('hello ', 'world!') as value; -- value 'hello world!'

Supported Signatures

function concat($3, array<$3>) returns array<$3>
function concat(array<$3>, ...) returns array<$3>
function concat(array<$3>, $3) returns array<$3>
function concat(varchar, varchar) returns varchar
function concat(varchar, ...) returns varchar

🔗 Official Documentation

​

concat_ws

Using the first array string0 element as separator, returns the concatenation of all subsequent strings string1, string2, … If `string0“ is null, then the return value is null. Any null values provided in the arguments after the separator are skipped.

Examples:

SELECT concat_ws('😊', 'hey', 'there', 'people') AS value; -- value 'hey😊there😊people'

Supported Signatures

function concat_ws(varchar, array<varchar>) returns varchar
function concat_ws(varchar, ...) returns varchar

🔗 Official Documentation

​

length

Returns the length of string in characters.

Examples:

select length('Hello World!') as value; -- value '12'

Supported Signatures

function length(varchar) returns bigint

🔗 Official Documentation

​

levenshtein_distance

Returns the Levenshtein edit distance of string1 and string2, i.e. the minimum number of single-character edits (insertions, deletions or substitutions) needed to change string1 into string2.

Supported Signatures

function levenshtein_distance(varchar, varchar) returns bigint

🔗 Official Documentation

​

lower

Converts string to lowercase.

Examples:

select lower('Hello World!') as value; -- value 'hello world!'

Supported Signatures

function lower(varchar) returns varchar

🔗 Official Documentation

​

lpad

Left pads string to size characters with padstring. If size is less than the length of string, the result is truncated to size characters. size must not be negative and padstring must be non-empty.

Examples:

select lpad('😉', 5, '*') as value; -- value '****😉'

Supported Signatures

function lpad(varchar, bigint, varchar) returns varchar

🔗 Official Documentation

​

ltrim

Removes leading whitespace from string.

Examples:

select ltrim('   😉') as value; -- value '😉'

Supported Signatures

function ltrim(varchar) returns varchar

🔗 Official Documentation

​

replace

Removes all instances of search from string.

Examples:

select replace('Hello There', 'There') as value; -- value 'Hello '

Supported Signatures

function replace(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

​

reverse

Returns string with the characters in reverse order.

Examples:

select reverse('Hello There') as value; -- value 'ereht olleH'

Supported Signatures

function reverse(array<$3>) returns array<$3>
function reverse(varchar) returns varchar

🔗 Official Documentation

​

rpad

Right pads string to size characters with padstring. If size is less than the length of string, the result is truncated to size characters. size must not be negative and padstring must be non-empty.

Examples:

select rpad('😉', 5, '*') as value; -- value '😉****'

Supported Signatures

function rpad(varchar, bigint, varchar) returns varchar

🔗 Official Documentation

​

rtrim

Removes trailing whitespace from string.

Examples:

select rtrim('😉   ') as value; -- value '😉'

Supported Signatures

function rtrim(varchar) returns varchar

🔗 Official Documentation

​

split

Splits string on delimiter and returns an array.

Examples:

SELECT split('hello+world', '+') as value; -- value '[hello, world]'

Supported Signatures

function split(varchar, varchar) returns array<varchar>
function split(varchar, varchar, bigint) returns array<varchar>

🔗 Official Documentation

​

split_part

Splits string on delimiter and returns the field index. Field indexes start with 1. If the index is larger than the number of fields, then null is returned.

Examples:

SELECT split_part('hello world', 'world', 1) as value; -- value 'hello'

Supported Signatures

function split_part(varchar, varchar, bigint) returns varchar

🔗 Official Documentation

​

starts_with

Tests whether substring is a prefix of string.

Examples:

SELECT starts_with('hello world', 'world') -- value 'false'
SELECT starts_with('hello world', 'hello') ; -- value 'true'

Supported Signatures

function starts_with(varchar, varchar) returns boolean

🔗 Official Documentation

​

strpos

Returns the starting position of the first instance of substring in string. Positions start with 1. If not found, 0 is returned.

Examples:

select strpos('Hello World', 'World') as value; -- value '7'

Supported Signatures

function strpos(varchar, varchar) returns bigint

🔗 Official Documentation

​

substr

This is an alias for substring().

Examples:

select substr('Hello World', 6) as value; -- value ' World'

Supported Signatures

function substr(varchar, bigint) returns varchar
function substr(varchar, bigint, bigint) returns varchar

🔗 Official Documentation

​

substring

Returns the rest of string from the starting position start. Positions start with 1. A negative starting position is interpreted as being relative to the end of the string.

Examples:

select substring('Hello World', 6) as value; -- value ' World'

Supported Signatures

function substring(varchar, bigint) returns varchar
function substring(varchar, bigint, bigint) returns varchar

🔗 Official Documentation

​

translate

Returns the source string translated by replacing characters found in the from string with the corresponding characters in the to string. If the from string contains duplicates, only the first is used. If the source character does not exist in the from string, the source character will be copied without translation. If the index of the matching character in the from string is beyond the length of the to string, the source character will be omitted from the resulting string.

Examples:

select translate('Hello World', 'Hell', 'N') as value; -- value 'No Word'

Supported Signatures

function translate(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

​

trim

Removes any leading and/or trailing characters as specified up to and including string from source.

Examples:

select trim('  😉  ') as value; -- value '😉'

Supported Signatures

function trim(varchar) returns varchar

🔗 Official Documentation

​

upper

Converts string to uppercase.

Examples:

select upper('Hello World!') as value; -- value 'HELLO WORLD!'

Supported Signatures

function upper(varchar) returns varchar

🔗 Official Documentation