Other String Functions

STR_LOWER(<str-expr>)                      Convert string to lowercase

STR_UPPER(<str-expr>)                      Convert string to uppercase

These two functions return a string value, which is the same as the input string, except that all letters are converted to lowercase or uppercase.

For instance, STR_LOWER("ABC123def") returns the string "abc123def".

STR_CLEAN(<str-expr>)                      Remove spaces from string

This function returns a string value, which is the same as the input string except that all space characters are removed from the input string.

For example, STR_CLEAN(" abc def ") returns "abcdef".