|
But then the HSQL documentation suggests that the full ANSI SQL variant is supported (http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#bfc_string_binary_functions):
TRIM
TRIM ([ [ LEADING | TRAILING | BOTH ] [ <trim character> ] FROM ] <char value expr> )
...
The character version of TRIM returns a character string based on <char value expr>. Consecutive instances of <trim character> are removed from the beginning, the end or both ends of the<char value expr> depending on the value of the optional first qualifier [ LEADING | TRAILING | BOTH ]. If no qualifier is specified, BOTH is used as default. If [ <trim character> ] is not specified, the space character is used as default.
|
