Skip to main content
Ben Nadel at NCDevCon 2016 (Raleigh, NC) with: Dan Skaggs
Ben Nadel at NCDevCon 2016 (Raleigh, NC) with: Dan Skaggs@dskaggs )

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 »