Vertica String
- overlay
Returns the "string_expression1", replacing "string_expression2" from character position numeric_expression. - btrim
Returns string_expression1 after removing the longest string of characters in string_expression2. - initcap
Returns "string_expression", with the first letter of each word in uppercase and all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. - lpad
Returns "string_expression1" padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. - ltrim
Returns "string_expression1", with leading characters removed up to the first character not in "string_expression2"; for example, ltrim ( 'xyxXxyAB' , 'xy' ) returns XxyAB. - to_hex
Returns the hexadecimal string representation of "numeric_exp1". - repeat
Returns the "string_expression" repeated "numeric_expression1" times. - replace
Returns "string_expression" having replaced "string_expression2" with "string_expression3". - rpad
Returns "string_expression1" right-padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. If "string_expression2" is not specified, then spaces are used. - rtrim
Returns "string_expression1", with final characters removed after the last character not in "string_expression2"; for example, rtrim ( 'ABxXxyx' , 'xy' ) returns ABxX. If "string_expression2" is not specified, the final space characters are removed.
Parent topic: Vertica