>>I have a table with a primary key field that contains data much like this:
>>A100
>
>Just out of curiousity.... why does it need be A100? Whats wrong with an integer?


Sorry for not replying sooner to you prompt post...

Why does it need to be A100? Because it has been ran this way for 9 years, and it is hard for the users to change... So, they decided to keep it this way...


Thanx,

Mike