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

SQL Escape Characters

Status
Not open for further replies.
Truble

Truble

Programmer
Joined
Mar 25, 2003
Messages
1
Location
CA
Hi all,

I am inserting some text into an Access database via a sql insert command.

However, the issue is the text contains some of the following characters:

'
"
%
_

What are the escape characters to insert those characters into the database?

sanks
 
Sort by date Sort by votes
Truble

I believe the escape character is the backslash \.

HTH,

Vic
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
Swi
  • Locked
  • Question Question
Jet Sql Statement - Select Distinct Multiple Columns
Replies
4
Views
1K
Swi
Swi
serino
  • Locked
  • Question Question
Help with SQL inner join statement
Replies
2
Views
618
serino
serino
Wolfdzn
  • Locked
  • Question Question
Join two seperate SQL into one
Replies
6
Views
856
dhookom
dhookom
dw134
  • Locked
  • Question Question
Working with SQL
Replies
2
Views
338
BrooksR
BrooksR

Part and Inventory Search

Sponsor

Back
Top