PMFJI people,
Have you thought of using PhDbase?
it doesn't just index memo filelds, it will index any character or memo field and its retrieval is on a par with SQL - for simple expressions it's fast, complex expressions you can make as slow as a HAVING clause <g>.
>> >>SELECT mytable
>> >>SET FILTER TO
>> >>alltrim(SUBSTR(ctitle,atc((substr(cname,1)),ctitle),len(cname)))=cname
>> >
>> >Do you have a tag on
>> alltrim(SUBSTR(ctitle,atc((substr(cname,1)),ctitle),len(cname)))?
>>
>> No. Do you think that is the better way to do it?
>
>most probably - YES
>I would also try to simplify the expression and do this in stages
>the later stages would be faster as you wil have a smaller sub-set of record to "work" on
>commands like ATC etc. take longer time to evaluate than simple indexes
>
>Arnon