update a record with a calculation
Posted: Tue Dec 12, 2006 1:55 pm
Hi,
Can I update a price (lower by a percentage) while running an update.
IE: update table SET price = price - (3/100)*price)
So far I can't get this to work, and something tells me I won't. <?>
Thanks,
DJ
Can I update a price (lower by a percentage) while running an update.
IE: update table SET price = price - (3/100)*price)
So far I can't get this to work, and something tells me I won't. <?>
Thanks,
DJ