You have to watch out for the delimiters. If the memo field is delimited with single quotes, which I think is the default, and you have a single quote somewhere in you memo field string, the update will fail. There is a setting for 'Quoted Identifiers' in the ODBC driver setup and in SQL Server that govern this behavoir. I choose to leave it set the way it was place and additional single quote next to all single quotes before an update. This way I can still use single quotes in my memo strings and the updates won't fail.

Charlie