[Query[ 100% to +7

Code:

---

UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '1500')

UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '4000')

UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '6000')

UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '7000')

---

Credits to equalled for providing query.
Credits to me for posting and expanding the query.

thanks ceelen!
i've been trying to figure this out