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