>Hi:
>
>It appears the SQL Server ODBC driver doesn't like double quotes. If you use double quotes around a string on updates, long strings and empty fields cause update failure. If you use single quotes all is fine. The Quoted Identifer setting appears to have no impact.
>
>This presents a problem for MEMO fields because you can't use any single quotes in the body of the text or the update will fail because it thinks it is an extra sting delimiter. Does anyone know of a work around for this?
>
>Thanx,
>Charlie
Charlie,
Its been an awful long time since I got to use SQL server, but I think you have to replace every occurance of a single quote, with 2 single quotes.
HTH
regards
Ian