Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 13, 2000



Application Security Testing: An Integral Part of DevOps

Embedded Apostrophe in a Query

When I pass a string containing an embedded apostrophe in a query to SQL Server, it sees the apostrophe as an end-of-string marker.


"Select * from Members Where LastName = 'O'Brien'"
What's the solution to this scenario?

SQL Server allows the use of either the apostrophe or the double-quote to delimit a string.

The easiest way to solve your problem is to use the double-quote character as your delimiter. This way, everything between the two quotes, including the apostrophe, is treated as part of the string.


Select * from authors Where au_lname = "O'Brien'"
works just fine.

Similarly, you could use the apostrophe to delimit the string when a quotation mark is in the string. So

"Thank you," he said
can be written as
Select '"Thank you," he said'

However, if you have both in the string, as in

"Don't do it," he said
you then have to resort to using a double delimiter. Whenever you either use " " or ' ', the system translates it as a signal to use the apostrophe or the quote as part of the string instead of a delimiter.


"Don't do it," he said
Select """Don't do it,"" he said"
DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date