>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
------------------------------------------------
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
