String Expression for contractions in SQL

Question

I am trying to search for string expression for a phrase that has a contraction. It a different deparment so I cannot have them change it to the full words. I get an error when I try to search for it.

"Disposition Name" IN ('Customer Doesn't Qualify')

But because of the ' in Doesn't I get an error. Is there some I can do with REGEXP_LIKE for it to work?

Possible duplicate of [How to insert a value that contains an apostrophe (single quote)?](https://stackoverflow.com/questions/1912095/how-to-insert-a-value-that-contains-an-apostrophe-single-quote) — Spencer Wieczorek, Feb 14 '18 at 23:39

score 1 · Answer 1 · answered Feb 14 '18 at 23:35

1

You can just escape the quote ' by replacing it with two single quotes '', for example;

"Disposition Name" IN ('Customer Doesn''t Qualify')

answered Feb 14 '18 at 23:35

Milney

6,253
2
19
33

Cool sounds easy. I’ll try it. Thanks. – Brian Wiley Feb 14 '18 at 23:41

String Expression for contractions in SQL

1 Answers1