char is right padded with spaces to the size of the string. Handy
for displaying data in columner format.
varchar is a variable length char that is NOT padded.
AFAIK, they both take up the same amount of space in the database,
however, varchar will return less data over the wire on queries
(char returns all those spaces in the pad). Char is the old way of
doing things from the old SQL Days.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com