Post reply

how to write a query where there is an ' in it

  • April 13, 2002 at 3:56 pm

    #77973

    I am trying to write the following query:

    select * from advertisers where Name = 'Scott's'

    Obviously this will not work. How do I put the single quote in the string?

    Thanks scott

  • April 13, 2002 at 4:54 pm

    #427165

    You can either change the outer single quotes to a double quote, or you can replace the embedded single quote with two single quotes, 'Scott''s'. I prefer the second method.

    Andy

    Andy
    Connect with me on LinkedIn

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

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