January 30, 2012 at 9:43 am
It's easy to find double quotation marks in a column with
LIKE '%"%'
But how do you search for single quotation marks? I can't seem to find a good answer to this, although maybe it's just me.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 30, 2012 at 9:50 am
Isn't it like this:
LIKE '%''%'
I've got two single quotes in there instead of one double.
John
January 30, 2012 at 10:19 am
OK, that was way too simple, but works well - thanks! The solutions I found before were different and they didn't work for me. But now I have it.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy