RTRIM(x,y)
RTRIM(x,y) is a string function that removes the blanks ( code attribute ASCII, UNICODE) from the end of the character string x and then all of the characters specified in the character string y (string specification).
The result of RTRIM(x,y), therefore, ends with the last character that was not specified in y. Only expressions that produce an alphanumeric value are permitted as string specifications.
|
x, y |
Result of the RTRIM(x,y) function |
|---|---|
|
RTRIM(x) |
Spaces only (code attribute ASCII, UNICODE) are removed from x. |
|
x is a NULL value |
NULL value |
SQL Tutorial, Changing Character Strings