jspring@gmail.com writes:
> So basically I want to ignore a single character (the apostrophe
> character), anywhere in the middle of my search word, in selecting
> results. How can I do this?
WHERE replace(name,'''','') like '%dont%'
Beware of quoting issues if "dont" is coming from user supplied inputs.
--
greg