Ah NULLS...just as controversial as spaces vs. tabs!
I especially use it for unknown datetime columns.
Let's say the table has a column for CreateDate and ModifiedDate, then ModifiedDate will be NULL until such time the record is actually modified by somebody.
Yeah, but are they as controversial as pointless aliasing:
SELECT * FROM Users U WHERE U.UserId = 12324