Returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a default value for null values when data is retrieved for display.
nullif
Returns a null value if value1 equals value2; otherwise it returns value1. This can be used to perform the inverse operation of the coalesce expression.
Returns the numeric code of the first character of the argument. In UTF8 encoding, returns the Unicode code point of the character. In other multibyte encodings, the argument must be an ASCII character.
bit_length
Returns the number of bits in a character string expression.
btrim
Removes the longest string containing any of the specified characters from the start and end of string.
char_length
Equivalent to length.
character_length
Equivalent to length.
concat
Concatenates two or more strings into one string.
concat_ws
Combines two values with a given separator.
chr
Returns the character based on the number code.
initcap
Capitalizes the first letter of each word in a string.
left
Returns the specified leftmost characters of a string.
length
Returns the number of characters in a string.
lower
Converts all characters in a string to their lower case equivalent.
lpad
Left-pads a string to a given length with a specific set of characters.
ltrim
Removes the longest string containing any of the characters in characters from the start of string.
md5
Calculates the MD5 hash of a given string.
octet_length
Equivalent to length.
repeat
Returns a string consisting of the input string repeated a specified number of times.
replace
Replaces all occurrences in a string of a substring with a new substring.
reverse
Reverses a string.
right
Returns the specified rightmost characters of a string.
rpad
Right-pads a string to a given length with a specific set of characters.
rtrim
Removes the longest string containing any of the characters in characters from the end of string.
digest
Calculates the hash of a given string.
split_part
Splits a string on a specified delimiter and returns the specified field from the resulting array.
starts_with
Checks whether a string starts with a particular substring.
strpos
Searches a string for a specific substring and returns its position.
substr
Extracts a substring of a string.
translate
Translates one set of characters into another.
trim
Removes the longest string containing any of the characters in characters from either the start or end of string.
upper
Converts all characters in a string to their upper case equivalent.