Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham and Demian Holmberg and Robert Dix and Paul Carney and Eric Pfleckl
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Colleen Lanham , Demian Holmberg@dah007 ) , Robert Dix@p_robert_dix ) , Paul Carney@perpetapaul ) , and Eric Pfleckl@epfleckl )

Anthony

Member since Jul 24, 2013

Recent Blog Comments By Anthony

  • SQL ISZERO() And NULLIF() For Dividing By Zero

    Posted on Jul 24, 2013 at 11:24 AM

    I found this at the site at bottom: you can use nullif() inside a SQL select statement, so user fuctinos are not needed. For example: A/nullif(B,0) AS [Percent] works without a user function. Zeros will return Null. http://stackoverflow.com/questions/861778/how-to-avoid-the-divide-by-zero-error-... read more »