Interesting, I don't think I've seen that while NULLs are very common.

I guess you would handle it in the application and not in the query, right?

I've seen it too, very often. But it's good if you can just keep NULL meaning NULL (i.e. "the absence of any value"), because otherwise you will eventually be surprised by behavior.