PDA

View Full Version : Sorting alphanumeric fields within browse


ABC123

alanc
04-24-2008, 08:17 AM
I have a field that is mixed alpha and numeric (coming from a MySQL active link). The natural sort sequence (and the default in Excel, for example) is :

C003A
C003B
C004A
C004B
C005A
C005B
etc

Within my browse this sorts as :
C003A
C004A
C005A
C003B
C004B
C005B

Is there a (preferably simple!) solution?

Many thanks.

Bill Griffin
04-24-2008, 09:07 AM
I just created a MySQL table, added the same records and seems to be sorting fine (See attached). Are you specifically sorting on the column?

alanc
04-24-2008, 09:21 AM
Bill

Many thanks - how much do I owe you?

I WAS sorting on the browse column - your answer prompted me to check whether I was using 'order by' in the link - I wasn't. Works fine now.

Much obliged!

Bill Griffin
04-24-2008, 09:25 AM
Glad I was able help.