Select command using right

[Gunnar Swan]

An index won't help. You can't use expressions and still use an index.
It'll have to go through every record.

If you know you always need the last four characters, I'd
copy them to a new field and index that.

2/18/03 10:42:43 AM, Yennie at aol.com wrote:

>Dang. What kind of index do you have for the field? Index by words or 
>ordinary index?
>Does left() work?
>
>Brian
>
>> Nope.
>> 
>> It gives the same results, nothing.
>> 
>> I think like and = would work the same in this situation.
>> 
>> Still stuck,
>> 
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>


Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses