Anthony
Member since Jul 24, 2013
- Profile: /members/11087-anthony.htm
- Comments: 1
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 »