In one particular case, I am getting an address string that has a strange character at the beginning of it that I get an error on when I try to insert into a DB2 table.
It looks like a staight line up and down right before my string.
When I ran a query on the particular record in VB, and try to display it in a grid, it does not display anything.
When I had someone run the query through the mainframe software, it shows the first character as a right bracket.
I tried doing a replace on a right bracket in my code before the insert, but it does not remove it. any ideas?
thanks,
Ryan Uhl