See my other reply to you about this ...
~~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.
>
>Sergey;
>
>Now that is a good question! I had not given it enough thought and you are so correct! I have done this for the wrong reasons! When you get into a bad habit you pay the price! :)
>
>Tom