UPDATE TESTFILE SET TRAN.NUMBER="" WHERE CONTROL.NUMBER.NFMT='9001' OR CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205'
Should do what you want.... George Basically, only clear out TRAN.NUMBER if CONTROL.NUMBER.NFMT is one of three values. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Riverman Sent: Thursday, August 22, 2013 1:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] SQL Update Multiple rows Here is the SQL example I am trying to follow UPDATE dbo.Product SET Availability=CASE When ProductId='1' Then '5' When ProductId='2' Then '5' When ProductId='6' Then '10' Else Availability END My attempts >UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' THEN '' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END; UniVerse/SQL: A WHEN clause must have at least one multi-valued column >UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' THEN '' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END; UniVerse/SQL: syntax error. Unexpected symbol. Token was "THEN". Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE CONTROL.NUMBER.NFMT = "900166550841" THEN Universe 10.1.1, Windows Server 2003 -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681.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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
