Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Question Unanswered: carriage return in a column

    Hi

    I have a carriage return (CR) in a field for some records in my database. How do I search for these records? Is it possible to search for the asci-code for CR?

    Something like this....???
    SELECT * FROM table1 WHERE column1 = ASCII(13)

    Thanks
    Johan

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    If you use OS Unix/Linux, then run unload to file text and run command cat filetext | sed 's/^M//' > file text good.


    Gustavo.

Posting Permissions

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