Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Jeff Coughlin
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Jeff Coughlin@jeffcoughlin )

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 »