>>>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...
Try :
index on upper(substr(fieldname,rat(".",filedname)+1))) to myindex
Beware this one assumes all have extensions.
Cetin