Skip to Content
1

How to escape in single quotes ' '' in LIKE

May 22, 2017 at 04:49 PM

44

avatar image
Former Member

How to tell single quotes in select with like?

Ex.:

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Paulo Meira De Melo May 22, 2017 at 05:51 PM
0

Hi!

You can try this:

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

Regards,

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

This solved my problem. Thank you.

0