Greenplum 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.
md5
Returns the MD5 hash of "string_expression1".
to_hex
Returns the hexadecimal string representation of "numeric_expression1".
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.
split_part
Returns "numeric_expression" field having split "string_expression1" on "string_expression2".

Parent topic: Greenplum