Hi!

IsAlpha ignores the rest of characters, so it will be simpler. Also, to index by number, better use val(). When yous till use string, keep in mind that all key values should be teh same length (that is not supported in your expression). So, you can use reliably eitehr of following expressions:

val(iif(IsAlpha(fieldname), Substr(fieldname,2), fieldname)) && numeric type


OR

iif(IsAlpha(fieldname), Substr(fieldname,2)+" ", fieldname) && string type

If values are integer, I would recommend also use BintoC() function.

Take care! :-)


>Hi Bill
>
>
>Index On Iif(IsAlpha(Substr(fieldname,1,1)), Substr(fieldname,2), fieldname) tag sometag
>
>
>Liam
>
>
>>Hi all
>>
>>I have filed that start with contains a character and then numbers and I want that it should be sorted on the number, but some times it has only a number with out any characters so I do id it
>>
>>thanx all