Guest_imported
New member
- Jan 1, 1970
- 0
how do i search a table ...
WHERE fldname = 'string's with quotes'
WHERE fldname = 'string's with quotes'
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!
-
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!
testing strings that contain single quotes in a SQL statement
- Thread starter Guest_imported
- Start date
- Status
I had posted this earlier. Hope it works for u too...
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.
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
