Skip to Content
1
May 22, 2017 at 04:49 PM

How to escape in single quotes ' '' in LIKE

71 Views Last edit Aug 28, 2017 at 07:36 AM 2 rev

How to tell single quotes in select with like?

Ex.:

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