If your update is not parameterised, the problem could be due to occasional single quote characters in the input, eg.

Update MyTable set Surname = 'O' Connor'

The update statement would terminate at the quote in the middle of the surname leaving the remainder of the line as an invalid SQL statement.