Sergey,

It sounds like you and I don't agree on the use of NULLs. We use NULL for most columns, unless it's a PK or an FK that *must* be populated. IMHO, a NULL is almost always different than empty. Even for character data.

~~Bonnie



>>>Yes, in SQL 2000 fixed lenght data types always take the same space regardless what value is stored in it.<
>>
>>Another good reason to use varchars!!! <g>
>
>I'm not sure why would you want to use Null in the char/varchar field in the first place unless empty values is not the same as Null.