[SQL] Update Problem

[Christian Paul Cosinas]

Hi,   I’m encountering some weird problem on Update.   I have a program that updates a table and it updates more than 1 column at a single query. Like this one:   Update table1 set column1 = ‘a’, column2 = ‘b’, column3 = time ’08:00 AM’ where column1 = ‘c’   Sometimes only column1 and column2 is updated and column3 is not updated.   What could be the possible cause of this?   Thanks, IANIAN