<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Using CASE Statements In A SQL UPDATE Query Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:933.view Date Posted: Aug 30, 2007 at 7:35 AM ---- --------------------------------------------------------------------------------------- ---> UPDATE [account] SET balance = ( CASE WHEN ((balance - 10.00) < 0) THEN 0 ELSE (balance - 10.00) END ) WHERE id = 1