I had to change "" to NULL. The field has a format of 8R so I assume SQL is interpreting this as a numeric field, not a string.
UPDATE TESTFILE SET TRAN.NUMBER=NULL WHERE CONTROL.NUMBER.NFMT='9001' OR CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205' -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681p41684.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users