How can I update a record of two specific column with a particular value

Change the total fee to 5000 whose STNO=1003, 1006, 1007

plz send me the exact query statement for this question......

Thanks, Churchi开发者_如何学Goll...

---

 update mytable set totalfee = 5000
 where stno in ('1003','1006','1007')

---

update [table] set [total fee]=5000 where STNO in (1003,1006,1007)