• What I meant with fixed-length, is you normally use char data type, when you expect the stored values to be of the same length. When they vary in size you should use varchar

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]