Hi David,
in a SQL string literal (or regular expression), an apostrophe is represented by '' (double apostrophe):
SELECT 'foo''bar' SIMILAR TO '_+''_+';
-> #t
Cheers,
—T
On Thu, Oct 14, 2021, at 12:31, Shaozhong SHI wrote:
> Can we check whether a text string contains apostraphe ' of not?
>
> Regards,
>
> David
--
| Torsten Grust
| teggy(at)fastmail(dot)com