<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Using NULLIF() To Prevent Divide-By-Zero Errors In SQL Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:984.view Date Posted: Oct 3, 2007 at 8:02 AM ---- --------------------------------------------------------------------------------------- ---> SELECT ( ISNULL( (45 / NULLIF( 0, 0 )), 0 ) ) AS value ; [ #qDivision.value# ]