Hi!

Then modify your expression:

Num=val(m.cObjValue)
iif(Num=0,'AAAA'+m.cObjValue,padl(Num,4,"0")+substr(m.cObjValue,len(alltrim(str(Num)))+1))

Note I did a mistake in the previos expression...

HTH.

>more info, A1, B2A, 10C, 3, B2 should be sort to 3, 10C, A1, B2, B2A...
>
>
>>Hmm.. how if the list contains a set of strings, each string have length 1-4, which can be any combination of 1-9, A-Z?
>>
>>such as A1, B2A, 10C, 3... etc.
>>
>>is it still possible to use asort? I still cant think of a way to do it yet..
>>
>>any idea?
>>
>>Jimi
>>