Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since May 2, 2010

Recent Blog Comments By Aakansha

  • Using NULLIF() To Prevent Divide-By-Zero Errors In SQL

    Posted on May 2, 2010 at 1:36 AM

    Hi, Excellent find! Using this I soved my problem. For e.g sum(objid)/nullif(count(units_purch),0) where count(units_purch) return 0 value. However I've one question can I solve this problem using CASE statement. If yes, then how? Thanks in advance! Regards, Aakansha... read more »