varying columns = varchar, varbinary.
A fixed length column, char for instance, will take up the assigned space where the contained value is NULL or not. I'm not sure of the behavior of varying columns. I'll have to do some checking and get back to you.
-Mike