Update query working intermitently

[chrisbrooke]

Ive got this update query that only works intermitently, which is a real pain, sometimes it comes back and say yeah ive update x amount of records, other times it just says a big fat 0! Is there a limit on how many records can be updated etc??

 

[namliam]

Nope no limit... but if you set a where clause and run the same query twice, the second time you might just get "0 records updated"

Might it just be that there actually is nothing to update?

Regards