Results 1 to 3 of 3

Thread: Finding embedded carriage returns

  1. #1
    Guest

    Finding embedded carriage returns

    What is the best way to query for columns which contain embedded carriage returns?

  2. #2
    Jonathan Yang Guest

    Finding embedded carriage returns (reply)


    Try clause like

    WHERE ACSII(substring(XXXX,n1,1)=13 ( or 10)



    On 8/3/98 9:28:41 AM, wrote:
    > What is the best way to query for columns which contain embedded carriage
    > returns?

  3. #3
    Lisa Guest

    Finding embedded carriage returns (reply)

    Thanks Jonathan,

    This works excellently if you know the position at which the Carriage return is located. However, I need to scan the database to identify (and subsequently correct) any columns which contain a CR anywhere inside the text. Any more ideas?


    On 8/3/98 7:35:19 PM, Jonathan Yang wrote:
    >
    Try clause like

    WHERE ACSII(substring(XXXX,n1,1)=13 ( or
    > 10)



    On 8/3/98 9:28:41 AM, wrote:
    > What is the best way to query
    > for columns which contain embedded carriage
    > returns?

Posting Permissions

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