String

Concat

Concatenates multiple strings into a single string. Treats NULL values as an empty string. –> learn more

CONCAT(@expression)

Return type

string

Parameters

Ends with

Determines whether a string is a suffix of another string –> learn more

ENDS_WITH(@expression, @expression_2)

Return type

boolean

Parameters

Format string

Creates a formatted string from input variables. Similar to the C printf function. –> learn more

FORMAT(@format_string, @expression)

Return type

string

Parameters

Length

Returns the number of characters in a string variable –> learn more

LENGTH(@variable)

Return type

integer

Parameters

Lower case

Return string value to lowercase –> learn more

LOWER(@variable)

Return type

string

Parameters

Pad left

Pad a string to the left with characters up to a certain total length –> learn more

LPAD(@variable, @return_length[, @pattern])

Return type

string

Parameters

Trim left

Removes all leading characters that match the provided pattern –> learn more

LTRIM(@expression[, @pattern])

Return type

string

Parameters

Normalize

Normalization is used to ensure that two strings are equivalent. Normalization is often used in situations in which two strings render the same on the screen but have different Unicode code points. –> learn more

NORMALIZE(@variable[, @normalization_mode])

Return type

string

Parameters

Regexp contains

Match a variable's values against a regular expression –> learn more

REGEXP_CONTAINS(@variable, @regex)

Return type

boolean

Parameters

Regexp extract

Returns the first substring that matches a regular expression –> learn more

REGEXP_EXTRACT(@variable, @regex)

Return type

string

Parameters

Regexp replace

Replaces all substrings that match a given regular expression with a new string –> learn more

REGEXP_REPLACE(@variable, @regex, @expression_2)

Return type

string

Parameters

Repeat

Return a string of a provided value repeated a set number of times –> learn more

REPEAT(@expression, @literal)

Return type

string

Parameters

Replace

Replaces all substrings that match a given string with a replacement string –> learn more

REPLACE(@expression, @match, @expression_2)

Return type

string

Parameters

Reverse

Reverses a string –> learn more

REVERSE(@expression)

Return type

string

Parameters

Pad right

Pad a string to the right with characters up to a certain total length –> learn more

RPAD(@variable, @return_length[, @pattern])

Return type

string

Parameters

Trim right

Removes all trailing characters that match the provided pattern –> learn more

RTRIM(@expression[, @pattern])

Return type

string

Parameters

Starts with

Determines whether a string is a prefix of another string –> learn more

STARTS_WITH(@expression, @expression_2)

Return type

boolean

Parameters

String position

Returns the 1-based index of the first occurrence of a substring within a string. Returns 0 if not found. –> learn more

STRPOS(@expression, @match)

Return type

integer

Parameters

Substring

Return the substring of a specified string –> learn more

SUBSTR(@expression, @position[, @length])

Return type

string

Parameters

Trim

Removes all leading and trailing characters that match the provided pattern –> learn more

TRIM(@expression[, @pattern])

Return type

string

Parameters

Upper case

Return string value to uppercase –> learn more

UPPER(@variable)

Return type

dynamic (input-dependent)

Parameters

Last updated