Thanks Josh,

I tried ? orgionally but got an error, must have been another syntax problem.

/Chris

>Try this instead:
>
>l_cSQL="UPDATE chronology SET cchronitem= ?l_cNotes WHERE nchronkey=1"
>
>The ? tells VFP to send the data in the variable. It handles every thing else for you.
>
>>I've come across a problem trying to update a memo field through ODBC.
>>
>>l_cNotes="This is test one"+CHR(10)+CHR(13)+"This is test two"
>>l_cSQL="UPDATE chronology SET cchronitem='"+l_cNotes+"' WHERE nchronkey=1"
>>iResult=SQLEXEC(g_cSystemConnect,l_cSQL,l_cCursor)
>>
>>The update fails with this message:
>>
>>"Command contains unrecognized phrase/keyword"
>>
>>Without the CR & LF it works fine. Is there a function to encode the CR & LF?
>>
>>TIA,
>>
>>/Chris