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 |
CONCAT_WS | Concatenate with separator. Returns a string resulting from the joining of two or more string values in an end-to-end manner. Uses the first argument as the separator between each string. |
CONTAINS | Returns TRUE if the first expression contains the second expression. |
FROM_HEX | Returns a binary value for the given hexadecimal string |
ILIKE | Tests whether an expression matches a pattern. The comparison is case-insensitive. |
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. |
LIKE | Tests whether an expression matches a pattern. The comparison is case-sensitive. |
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 |
REGEXP_LIKE | Returns true when the specified regular expression matches values in a column. Otherwise, returns false. |
REGEXP_MATCHES | Returns true when the specified regular expression matches values in a column. Otherwise, returns false. |
REGEXP_REPLACE | Finds strings that match the given regular expression and replaces the strings with the given string. |
REGEXP_SPLIT | Splits an input string by using a regular expression according to a keyword and an integer value. |
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. |
SIMILAR_TO | Tests whether the entire expression matches a pattern. |
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. |
TOASCII | Converts a string that is encoded in the specified character set to UTF-8. |
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. |
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.