Sybase IQ now supports the following string functions:
LEN Returns the number of characters, not the number of bytes, of a specified string expression, excluding trailing blanks
REVERSE Returns the specified string with characters listed in reverse order
STR_REPLACE Replaces any instances of the second string expression (string_expr2) that occur within the first string expression (string_expr1) with a third expression (string_expr3)
For more information, see Chapter 5, “SQL Functions,” in the Sybase IQ Reference Manual.
