SQL statements in ASP - beware the apostrophe

One of the most common problems encountered in ASP when using SQL statements, is the existence of an apostrophe (i.e. single quotation mark) in an SQL query string. I say problem because SQL Server (or any T-SQL database server) interprets single quotes as the representation of a string value - that is, as delimiters. Therefore to avoid conflict between single quote delimiters and apostrophes we need to let ASP know that we want an actual apostrophe and not the end of the string. My short tutorial will show you how.....so let's get started