Thanks very much :)
Just think it should be Num=int(val(m.cObjValue))
Thanks again!
jimi
>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
>>>
error(503): file structure failure, signature file corrupted.