-- see if the record exists in the table.
select * from billing.acct
where accountnumber = '1234' and finalbillflag = 'F' and credflag = 'N';

-- update columns in the record.
update billing.acct set 
	closeoutdate = '20121231',
	closedby = 'tahseenm'
where accountnumber = '1234' and finalbillflag = 'F' and credflag = 'N';

quote:

---

Originally posted by tahseenm

So I use the second script to update or some changes on it. Let me know.

I need to update the record that has the accountnumber=56073-06, finalbilling=Y, credflag=Y.

Currently the record has finalbilling=N,credflag=N

Let me know. Thanks

moetahsen

---