>Justok,
>
>You are incorrect, PADL(...,7) will give this sort order.
...
>You can create an index on;
>
>SalesPersonID + CustomerID to get the BJ, KK stuff sorted out within the number.
>
>Your problem here is that you first need to left pad your keys so they all have increasing values. Second you need to correct the table design so that the fields are atomic, that is they cannot be broken apart and still retain meaning. Right now you are using one field to do the work that requires two fields to do.

---

Thanks, you're right. User should not make any strange behaviour on primary key

I give a new column agent_no which tell the sales the company is followed by with agent company!

Then, "128DJ" can re-assign to new cust_no with a RefCust_no carry to old cust_no value for reference and the agent_no will be "128" for indication!!