At 12:01 PM 10/19/2004, robert-wagner@... wrote:

>why is it bad to use varchar for character strings less than four
>characters? Only because of the 2 extra bytes holding the string length

Yes, that plus the effect it will have on data compression. The
length, being binary won't compress with the string and since the
string is too short to compress the whole lump will sit in the
record, uncompressed.


Regards,


Ann