<--- --------------------------------------------------------------------------------------- ---- 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 ---- --------------------------------------------------------------------------------------- ---> Max( 0, (balance - void_credit) )