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

    Unanswered: Seaching for strings using hex constant

    Hi all,

    Some of the char varying columns in my database have single quotations entered as hex 92. I would like to change them to Hex 27 because the COPY command chokes when it hits them in a psql script.

    select name
    from school
    where name like '%' ||cast(x'92' as char) || '%'

    does not work to select the rows I need.

    Is there a way to do this in the database?

    Thanks,

    Jon

  2. #2
    Join Date
    May 2008
    Posts
    277
    Maybe the replace function?

Posting Permissions

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