Hi Joe,

Fred's solution will do the trick for you. As another possible solution have you considered creating an SQL stored procedure and passing the string to it along with the id# to do the update? This should get around the ODBC quoted identifier issue, and allow SQL itself to perform the update.