Jules
Member since Aug 14, 2014
- Profile: /members/12200-jules.htm
- Comments: 1
Recent Blog Comments By Jules
-
Why NULL Values Should Not Be Used in a Database Unless Required
Posted on Aug 14, 2014 at 11:14 AM
@Ben, "Sure thing boss, I will just grab all records whose SSN field has a ZERO length." I'd see it as a bit of a red flag if anyone preferred ...WHERE LEN(SSN)=0 over either ...WHERE SSN = '' or ...WHERE SSN IS NULL regardless of the potential confusion over which magic no-data value yo... read more »