<div>
of course, using <a href="https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/A_3626-ASP-Classic-Using-Parameterized-Queries.html" rel="ugc">parameterized queries</a> would be much simpler and safer to do
</div>


of course, using parameterized queries [https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/A_3626-ASP-Classic-Using-Parameterized-Queries.html] would be much simpler and safer to do

<div>
Thank you very much for your help. This also solved the problem:<br />
<br />
sLast_Name=replace(rs2(&quot;La<wbr />st_Name&quot;),<wbr />&quot;'&quot;,&quot;''&quot;)
</div>


Thank you very much for your help. This also solved the problem:

sLast_Name=replace(rs2("Last_Name"),"'","''")

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I'm trying to insert last names like O'Neil into my database, but it gives me an error because of the single quote in the last name.<br />
It works with names without single quotes. <br />
This is how I'm doing it:<br />
<br />
sLast_Name=rs2(&quot;Last_Name&quot;<wbr />)<br />
<br />
Ho can I rewrite this so that it accepts single quotes.<br />
<br />
Thank you
</div>
</div>


Hi Experts,
I'm trying to insert last names like O'Neil into my database, but it gives me an error because of the single quote in the last name.
It works with names without single quotes. 
This is how I'm doing it:

sLast_Name=rs2("Last_Name")

Ho can I rewrite this so that it accepts single quotes.

Thank you

Insert single quote in Classic ASP

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.