RTRIM

RTRIM(str[, chars])

Removes trailing characters from a string column/literal str. These characters are specified by chars or are whitespace.