>>It may be better to store the prefix in a varchar() field
>
>Yes and No, Varchar field is optimized for variable length. In this case, I may end up with thousands of records and their length would differ.

Seems like that would be an ideal case for varchar.