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
>>
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.