Skip to Content
avatar image
Former Member

How to escape in single quotes ' '' in LIKE

How to tell single quotes in select with like?

Ex.:

SELECT UPPER(T0."CardCode") FROM CRD1 T0 WHERE T0."Address" LIKE '%\'%' ESCAPE '\'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 22, 2017 at 05:51 PM

    Hi!

    You can try this:

    SELECT UPPER(T0."CardCode") FROM CRD1 T0 WHERE T0."Address" LIKE '%' || CHAR(96) || '%'

    Regards,

    Add comment
    10|10000 characters needed characters exceeded