Your application of course will need to support it, and SQL server doesn't have a native "attribute" that I know of to say that "NULLs aren't allowed, but zero-length strings are...", you could ...