Post reply

Where statement on a ' mark

  • June 26, 2012 at 11:51 am

    #260496

    I need to filter all the records that have a ' mark. I tried Where Fieldname like '%[']%' but it returns "Unclosed quotation mark after the character string '

  • June 26, 2012 at 12:00 pm

    #1505765

    FutureQueryArtist (6/26/2012)

    I need to filter all the records that have a ' mark. I tried Where Fieldname like '%[']%' but it returns "Unclosed quotation mark after the character string '

    Try: Where Fieldname like '%['']%' -- That is 2 single quotes.

Viewing 2 posts - 1 through 1 (of 1 total)

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