hi Agnes,

I would include lower case as well (verify the strings)


>INDEX ON chrtran(c1,'ABCDEFGHIJKLMNIOQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789','0123456789ABCDEFGHIJKLMNIO0123456789ABCDEFGHIJKLMNIOQRSTUVWXYZ') TAG _c2


>Hi Gregory,
>
>that seems to be the start.
>
>I think I will simply use something like
>

>INDEX ON chrtran(c1,'ABCDEFGHIJKLMNIOQRSTUVWXYZ0123456789','0123456789ABCDEFGHIJKLMNIOQRSTUVWXYZ') TAG _c2
>

>
>> ...re-educate the customer...
>
>I have no idea what to teach them here.
>
>Agnes
>
>>Agnes,
>>
>>The sort order of the Windows Explorer is described here http://windowsxp.mvps.org/xpsortorder.htm
>>
>>The only way out for you is to have an extra field in your cursor with the filename strtran() in such a way that the digits come after the alphabet
>>eg map
>>a, A to hex 01
>>b, B to hex 02
>>...
>>
>>0 to 0x01 + 0x20 or so
>>
>>Then the index has to be Machine
>>
>>
>>Then you have to watch out for the accented chars + eszet
>>
>>You can try to re-educate the customer...