String Functions

chr(col): Returns the Unicode code point n as a single character string.

codepoint(col): Returns the Unicode code point of the only character of string.

length(col): Returns the length of string in characters.

upper(col): Converts a string expression to upper case.

lower(col): Converts a string expression to upper case.

ltrim(col): Removes leading whitespace from string.

reverse(col): Returns string with the characters in reverse order.

rtrim(col): Removes trailing whitespace from string.

trim(col): Removes leading and trailing whitespace from string.

word_stem(col): Returns the stem of word in the English language.