Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WHERE clause 1

Status
Not open for further replies.
stubing

stubing

IS-IT--Management
Feb 23, 2002
1
CA
trying to solve this situation:

SELECT * FROM tblname WHERE fldname='ryan's question'


there is a nested single quote in my literal string which is causing the query to fail, I'm sure there is a simple solution for this problem yet it illudes me.
 
Sort by date Sort by votes
You may try :
double quotes :
SELECT * FROM tblname WHERE fldname="ryan's question"

OR
two single quotes
SELECT * FROM tblname WHERE fldname='ryan''s question'

Let me know if it worked.
 
Upvote 0 Downvote
The second example works well :)
Andel
maingel@hotmail.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mchambers
  • Locked
  • Question
Error - in Where clause 1
Replies
2
Views
324
mchambers
mchambers
appelq
  • Locked
  • Question
SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas 1
Replies
7
Views
584
appelq
appelq
VijiKumara
  • Locked
  • Question
Unable to query a a table with a value having special character 'single quote' in where clause 1
Replies
6
Views
319
dhookom
dhookom
craigward
  • Locked
  • Question
SUM rows where value = DT 1
Replies
4
Views
232
craigward
craigward
grnzbra
  • Locked
  • Question
Stop Check of SELECT Clause
Replies
2
Views
187
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top