Handling Apostrophes in ASP and SQL

SQL Commands on ASPIsFun

An important step when using character data in SQL and ASP is making sure that any apostrophes (‘) in the data doesn’t interfere with your SQL statement! Your SQL statement is going to have apostrophes around each text value. If your text value has an apostrophe IN it, the SQL parser will think it’s hit the end of the text value, before it really has.

Handling Apostrophes in ASP and SQL

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.