Aster Data String
- overlay
Returns the "string_exp1" replacing "string_exp2" from character position numeric_exp. - btrim
Returns string_exp1 after removing the longest string of characters in string_exp2. - initcap
Returns "string_exp", 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_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 characters removed up to the first character not in "string_exp2", e.g., ltrim('xyxXxyAB', 'xy') returns 'XxyAB'. - md5
Returns the MD5 hash of "string_exp1". - to_hex
Returns the hexadecimal string representation of "numeric_exp1". - repeat
Returns the "string_exp" repeated "numeric_exp1" times. - replace
Returns "string_exp" having replaced "string_exp2" with "string_exp3". - rpad
Returns "string_exp1" right-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. If "string_exp2" is not specified, then spaces are used. - rtrim
Returns "string_exp1", with final characters removed after the last character not in "string_exp2", e.g., rtrim('ABxXxyx', 'xy') returns 'ABxX'. If "string_exp2" is not specified, the final space characters are removed. - split_part
Returns "numeric_exp" field having split "string_exp1" on "string_exp2".
Parent topic: Aster Data