INDEX ON A SUBSTRING

Need to build an index based upon a substring of a Field in a Table.   For
example, a field called CONTROL
has 14 characters.

Here is what a typical entry into the CONTROL field would look like:

MISC 000300052

I need to index the table by the last 5 characters in that field.   The
field is a String Type.

Is that possible?  How, exactly, would that be done.

In xBase,  the line of code would be:

     Index On SubStr(CONTROL,10,5) to SomeIndex

Thanks

Richard Wakeman
wake...@thegrid.net