>>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.
Dunno what you mean - but you wouldn't need TRIM
Gregory