String

Function Name Description
ASCII Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.
BTRIM Trims leading and trailing characters from a string.
CHARACTER_LENGTH Returns the length of an input string.
CHAR_LENGTH Returns the character length of the input string
CHR Converts a Unicode code point into the character that matches the input Unicode character. If an invalid code point is specified, an empty string is returned.
CONCAT Concatenates two or more strings
CONTAINS Returns TRUE if the first expression contains the second expression.
FROM_HEX Returns a binary value for the given hexadecimal string
ILIKE Compares two strings and returns true if they match.
INITCAP Returns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).
IS_UTF8 Returns whether an expression is valid UTF-8
LEFT Returns the left-most substring. The function name must be enclosed in double quotes ("LEFT").
LENGTH Returns the length of an input string. If the character encoding isn’t specified, it assumes to UTF8.
LOCATE Searches for the first occurrence of the first argument in the second argument and if found, returns the position the of the first argument in the second argument. The first character in a string is position 1. Returns 0 if the substring isn’t found in the expression.
LOWER Returns the input expression with all the characters converted to lowercase.
LPAD Left pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
LTRIM Removes leading spaces or characters from a string.
OCTET_LENGTH Returns the length of the string in bytes.
POSITION Returns the position of the first occurrence of a substring within another string
REPEAT Builds a string by repeating the input for the specified number of times
REPEATSTR Repeats the given string n times.
REPLACE Removes all occurrences of a specified substring and replaces them with another string.
REVERSE Reverses the order of characters in a string.
RIGHT Returns the right-most substring. The function name must be enclosed in double quotes (“RIGHT”).
RPAD Right pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
RTRIM Removes trailing spaces or characters from a string.
SPLIT_PART Splits a given string at a specified character and returns the requested part.
STRPOS Searches for the first occurence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported.
SUBSTRING Returns the portion of the string from the specified base expression starting at the specified chracters.
TO_HEX Returns a hexadecimal string for the given binary value.
TRANSLATE Translates the base expression from the source characters/expression to the target characters/expression.
TRIM Removes leading, trailing, or both spaces or characters from a string
UPPER Returns the input expression with all the characters converted to uppercase.