You can create User Defined Data Types that had the necessary Null values you want defaulted for that data type, but you would have to use that data type when creating tables. I don't believe that you can alter the existing data types.
Microsoft Certified Master - SQL Server 2008 Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]