I am trying to append text to a memo field through the SQLExec statement from my VFP6.0 app. I get an error when executing a statement like the following:

SQLEXEC(gnHnd, "UPDATE mytable SET xxNotes = xxNotes + ?lcNote")

I also tried the following, but it only saves the first few chars:

SQLEXEC(gnHnd, "UPDATE mytable SET xxNotes = CAST(xxNotes AS varchar) + ?lcNote")

Any ideas? Thanks
-Brett