hi pando,

i have used the rtrim function to remove the blank spaces in the column. As the files that we have received have only blank spaces to the right of the data column. eg., '00008___'.
Here ____ represents blank spaces. Now I have to get rid of it.

I have used RTRIM function in SQL LOADER CTL file and have failed.
Hope this sends you a clear picture.


regards
ICEMAN