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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Apostrophies

Status
Not open for further replies.
Horsegag9

Horsegag9

Technical User
Joined
Jan 25, 2005
Messages
9
Location
AU
Hello All,

What is the syntax for including a single quote or ' in my query? I know you have to wrap it in something, but I can't remember what it is.

Thanks in Advance
Horse
 
Sort by date Sort by votes
Here's an example....
Code: 
INSERT myTable (LastName)
VALUES ('O''Donnell')

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

aljubicic
  • Locked
  • Question Question
Replace Apostrophies??
Replies
3
Views
101
psnivas
psnivas
aljubicic
  • Locked
  • Question Question
Replace Apostrophies for Openquery??
Replies
6
Views
335
SQLSister
SQLSister

Part and Inventory Search

Sponsor

Back
Top