Single quote in insert statement

[JustWondering]

Hi,

When I tried to insert a value with a postrophe, it became "" in my table.


name= Kelly's Pan

strSQL="INSERT INTO mytable " & _
"VALUES ('" & name & "','" & email & "') "

How can I avoid this and still doesn't effect other values(without apostrophe)?

Thanks

 

[onpnt]

replace them
there's a few threads here in this forum in replace the quotes

_____________________________________________________________________

http://www.onpntwebdesigns.com/aspTut4.asp