Inserting into a database? Double it. For example from VB, we use this syntax (but I don't think that Replace exists in VBScript):
strX = "O'Neil"
SQL = "SELECT * FROM Table1 WHERE LastName = '" & replace(strx,"'","''") & "'"
>I am using VB script as server script and facing problem of insertion a text containing single quote.
>
>I would appriciate if some could help me
>
>Shahid
>Web developer
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com