Doug --
A couple pieces:
1. Your assignment to xcomments gives a syntax error because you've included a quotation mark in a string and are delimiting the string with a quotation mark. So, VFP can't understand the end of the string -- !!{}[]-+=).".
You're using all the possible string delimiters in the assigned string -- "", '', and []. If this situation actually could occur in the application, and you are programmatically generating the string, assign it as 2 strings, as follows:
cComments = "'[]" + '"'
2. In the INSERT statement, you need to identify the fields that you're assigning, not just the table. For example:
INSERT INTO feedback (cUserComm) VALUE(xcomments)
If you make those changes, I think you'll get this to work.
Jay
>Can I specify in an SQL Insert statement that a value is to be placed in a memo field.
>
>Here's what I'm trying:
>
>xcomments = "anything that has special characters like (.,;'"!!{}[]-+=)."
>
>INSERT INTO feedback VALUE(xcomments)
>
>I get syntax errors or command errors becuase the is reading the contents of the string. I've tried macro substition, and it doesn't like the &. I've search my msdn library and now I'm at wits end.
>
>Help, please.