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.
Leave a Reply