• RTRIM only clears off spaces on the right side of the text. So, you better use LTRIM(RTRIM(ID)) in your source query itself.