Returns the characters of the argument with trailing blanks removed.
The schema is SYSFUN.
- expression
- The expression can be of any built-in character string data type.
For a VARCHAR the maximum length is 4 000 bytes and for a CLOB the maximum length is 1 048 576 bytes.
The result of the function is:
- VARCHAR(4000) if is VARCHAR (not exceeding 4 000 bytes) or CHAR
- CLOB(1M) if expression is CLOB or LONG VARCHAR
The result can be null; if expression< is null, the result is the null.
© Copyright IBM Corp.