RTRIM will remove the trailing spaces, but when you save the data into a table, the spaces will be added again.


>my mistake Craig I was under the assumption it would remove the trailin spaces and I would see the last digit of the zip code as the rightmost character