How about this:
index on left(fieldname,1)+padl(alltr(substr(fieldname,2)),5,"0") tag fieldtag ?

>>>>>>>>>>>>>>>>your message below
I have a table with a primary key field that contains data much like this:

A100
A1000
A110
A1100
A124
A1240

I would like to sort this data so that:

A100
A110
A124
A1000
A1100
A1240

How exactly do I do this? It must be right in front of my face... I just dont see it...

Thanx,


Mike