Similar to Michael's solution, there is an ADO Parameter object that you can use instead of creating a massive SQL string. In addition eliminating the need for parsing, it will validate each field in your SQL insert command.

-Dave


>Hi everyone.
>
>Here's what I'm trying to do. I have a form that has a comments field on it, and when the user hits submit I email the form answers to my address. Using CDONTS is easy and great for this.
>
>But here's where I run into problems. I'm using the INSERT SQL Command to add a record to my feedback database. If the user enters any special characters, like period, comma...whatever....iget the syntax error or some other error.
>
>I'm using Foxpro databases(dbf) with a memo field for the comments. I've tried Macro Substituition with Vbscript, and i've also written the comments out to a text file. But I really need to know if there is a command that I can include in the SQL statement that will do the job quick and clean.
>
>Thanks.