ScottPletcher (1/3/2013)

---

If you're providing data for report or any type of BI application, remove NULLs entirely. NULLs cause serious and severe logic considerations that most people don't fully understand (including even some "DBAs").

If ANY user, even a power user, needs to write queries against the data, NULLs should especially be avoided and will cause you far more headaches than they are worth.

Replace any NULLs either with blank or 'Unknown' or equivalent that is clear to the end-users and that they support.