# \-ASP- Inserting ' character

**URL:** <https://forum.kirupa.com/t/asp-inserting-character/30840>\
**Category:** programming\
**Created:** [September 15, 2003, 5:40am UTC](https://forum.kirupa.com/t/asp-inserting-character/30840 "2003-09-15T05:40:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 15, 2003, 5:40am UTC](https://forum.kirupa.com/t/asp-inserting-character/30840/1 "2003-09-15T05:40:18Z")

</div>

Having a problem when the user try’s to insert the ’ character. I can’t seem to replace that character, is that what I should be doing?

Everything works fine until the ’ comes about, any idea’s?

```auto

<% @ Language=VBScript %>
<% 
   a=Request.Form("author")
   e=Request.Form("author_email")
   q=Request.Form("question")
   ans=Request.Form("answer")
%>
<!--#include file="connection.asp"-->
<% SQL = "INSERT INTO FAQ (name, email, question, answer) VALUES ('"&a&"','"&e&"','"&q&"', '"&ans&"')" 
conn.Execute(SQL) %>

```