String Functions

This section contains the reference documentation for the String functions built into Splice Machine SQL:

Function Name Description
Concatenate Concatenates a character string value onto the end of another character string. Can also be used on bit string values.
INITCAP Converts the first letter of each word in a string to uppercase, and converts any remaining characters in each word to lowercase.
INSTR Returns the index of the first occurrence of a substring in a string.
LCASE or LOWER Takes a character expression as a parameter and Returns a string in which all alpha characters have been converted to lowercase.
LENGTH Applied to either a character string expression or a bit string expression and Returns the number of characters in the result.
LOCATE Used to search for a string within another string. 
LTRIM Removes blanks from the beginning of a character string expression.
REGEXP_LIKE Returns true if a string matches a regular expression.
REPLACE Replaces all occurrences of a substring with another substring
RTRIM Removes blanks from the end of a character string expression.
SUBSTR Return a portion of string beginning at the specified position for the number of characters specified or rest of the string.
TRIM Takes a character expression and Returns that expression with leading and/or trailing pad characters removed. 
UCASE or UPPER Takes a character expression as a parameter and Returns a string in which all alpha characters have been converted to uppercase.