>Why shouldn't I just always choose varchar when I need a character field in SQL Server?
>Are there some advantages char has over varchar if the data is say always 5 characters long?
There is slightly more overhead with a varchar as opposed to a char. If you know that the data is always 5 characters long, use char.
Chris McCandless
Red Sky Software