>>I want to index on the last three letters of a file name
>>and get a list indexed by file extension.
>
>Firstly, you shuld collect file names/extensions into cursor (using ADIR()). Then you can index your cursor and use it for list.
---
Hi Ed and thanks...
I have a table with files name in it.
I want to index on the extensions.
I am looking for the index code.. example
index on surstr(fieldname,right(filedname,3)) to myindex - or something
like that...