Trailing spaces

[reddy]

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

[DSguru2B]

A box character huh. See if the following works for you

Code: Select all

CONVERT(".","",OCONV(in.Col, "MCP"))

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.

[chulett]

You need to find out what the characters are, obviously they're not spaces. Dump to a flat file and then use a hex editor to examine the file.

[remo]

Looks like u have nulls padded....nulltoempty function should help you out