>>>>I want to index on the last three letters of a file name
>>>>and get a list indexed by file extension.
>>>
>>>Assuming that you have filenames loaded into a "files" column of a table:
>>>
>>>INDEX ON RIGHT(ALLTRIM(files),3) TO ext_index
>>---
>>Hi John and that works - thanks :))
>
>Or load foxtools and:
>
>INDEX ON JustExt(file) TO ext_index
Technically, that's a lot more accurate than my solution, although it may be slower on large tables. Thanks, George!
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05