Vectorwise String

lpad
Returns "string_exp1" padded to length "integer_exp" with occurrences of "string_exp2". If "string_exp1" is longer than "integer_exp", the appropriate portion of "string_exp1" is returned.
ltrim
Returns "string_exp1", with leading blank characters removed.
rtrim
Returns "string_exp1", with trailing blank characters removed.
shift
Returns "string_exp1" shifted by numeric_exp character. If "numeric_exp" is greater than zero shift to the right else shift to the left.
soundex
Returns a four character code for the "string_exp1".
squeeze
Returns "string_exp1" with multiple whitespace characters collapsed into a single whitespace character.

Parent topic: Vectorwise