Urgent: Weird characters in string(Resolved)
Hi
I am doing a data conversion from AS400 to SQLSErver and using VB as the data manipulation tool. In some of the string fields I have charaters that looks like squares.
I used the replace function to search and replace chr$(13) and chr$(10) characters, but was unsuccessful. These characters causes a syntax error in my SQL statement with error "Unclosed quotes"
Does any one have an idea how to get rid or replce these characters? Obviously chr$(13) and chr$(10) is incorrect.
Thnx