Post reply

Searching for Single Quotation Marks in a Table's Text Column

  • January 30, 2012 at 9:43 am

    #263561

    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

    #1440100

    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

    #1440135

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply