<div>
Try this:<br />
chr(34) = &quot;<br />
chr(39) = '<br />
MyComments = Request.Form(&quot;comments&quot;)<br />
MyComments = Replace(MyComments ,chr(34),chr(39))
</div>


Try this:
chr(34) = "
chr(39) = '
MyComments = Request.Form("comments")
MyComments = Replace(MyComments ,chr(34),chr(39))

<div>
Thanks for the reply, I get an error with the script <br />
<br />
Microsoft VBScript compilation error '800a0409' <br />
Unterminated string constant <br />
/AddComments.asp, line 39 <br />
chr(34) = &quot;<br />
-----------^<br />
<br />

</div>


Thanks for the reply, I get an error with the script

Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/AddComments.asp, line 39
chr(34) = "
-----------^



<div>
Cool thanks - apologies about the comment - it was me being daft! thanks again!
</div>


Cool thanks - apologies about the comment - it was me being daft! thanks again!

<div>
No worries - glad I could help. &nbsp;Thanx for the grade! :^)
</div>


No worries - glad I could help.  Thanx for the grade! :^)

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm rying to replace some special characters from a string before submittng to a DB, in particualr the &quot;, I know I can use the replace command but cannot get this working for &quot;&nbsp;with '<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MyComments = Request.Form(&quot;comments&quot;)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MyComments = Replace(MyComments ,&quot;&quot;&quot;&quot;,&quot;'&quot;)
</div>
</div>


Hi,
I'm rying to replace some special characters from a string before submittng to a DB, in particualr the ", I know I can use the replace command but cannot get this working for " with '

	MyComments = Request.Form("comments")
	MyComments = Replace(MyComments ,"""","'")

Replace characters from string

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.