>>Prior to SQL 7.0 char column with Null value wouldn't take any space at all. Imagine some people surprise when there DB size went over the roof after converting to SQL 7. :)<
>
>So, the same applies to SQL 2000? NULLs take up the whole space reserved for the datatype?
>
Yes, in SQL 2000 fixed lenght data types always take the same space regardless what value is stored in it.