Hi,
I have data in a XYZ (table A) trailing with special character small square box in db2.
I know this is not just space to trim, I do not know what that character is??
I am using the above said XYZ column to join with another table B using join stage
and the join fails as the table A data has square brackets and the table B doesn't.
table A
-------
XYZ (char(20))
123AB4567<square box>(10 to 20)
table B
-------
XYZ (char(20))
123AB4567
Any thoughts on getting rid of square box and join two tables are greatly appreciated.
Thanks.
small square box
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Did the file come from Windows? Then the character is likely to be Ctrl-M (carriage return) which you can represent as Char(13). Use a hex editor to find out what this character actually is.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Chuck Smith
www.anotheritco.com
www.anotheritco.com