Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
Apr 12, 2000

Apostrophe causes syntax error in SQL query

Question:
I have a problem with the add and update query in SQL. I am trying to update the database with a string which contains one or more apostrophes. SQL reads it like a syntax in query and gives an error message. What I can do? Are there other text delimiters? I have tried "",[], or {} or double apostrophe without success.

Answer:

Before sending data to your SQL Server, convert all your apostrophes (') in data to double apostrophes (").

So, if a user name is O'Brian, the apostrophe will cause a problem in your SQL Statement:

Update Table Set NameField = 'O'Brian'
Instead, you need to convert it to double apostrophes:
Update Table Set NameField = 'O"Brian'
To convert single apostrophes to double, use the Replace function.
strName = Replace(strName, " '" , """ )
DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

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