slr@cnicorp.com
Newbie
Points: 1
More actions
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
Andy Warren
SSC Guru
Points: 119902
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
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply