Results 1 to 5 of 5

Thread: Urgent: Weird characters in string(Resolved)

Threaded View

  1. Apr 15th, 2003, 04:02 AM #1
    quasar_sa
    quasar_sa is offline

    Thread Starter
    Member
    Join Date
    Oct 2002
    Location
    South Africa
    Posts
    47

    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
    Last edited by quasar_sa; Apr 15th, 2003 at 07:37 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width