It's difficult to verify without knowing which database and which version of the database you're using.

That said, it's pretty easy to verify an update by turning it into a select and running it against your test database. It's also often possible to run it through your database's query analyzer, which should tell you about syntax errors.