Function documentationRTRIM(x,y) Locate this document in the navigation structure

 

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.

RTRIM(x,y)

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

Example

SQL Tutorial, Changing Character Strings

More Information

TRIM(x,y)

LTRIM(x,y)