Good morning guys,
I am transfering data from ODBC stage to Oracle stage both source and target columns are varchar2 datatype.In one of the column I am getting trailing spaces.i used trim function to remove those spaces butit didn't work.I am thinking those are not spaces may be tab or some other characters.When I ran the query in the toad it is showing boxes symbol at the end.
Could you please help me on how to remove trailing characters.
Regards
Narasa
Trailing spaces
Moderators: chulett, rschirm, roy
A box character huh. See if the following works for you
Test it out with the above command. If it works then make sure you dont have any dots in your data before accepting it as a solution.
Code: Select all
CONVERT(".","",OCONV(in.Col, "MCP"))
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.