Patrick,

In addition to what Fabio said, I believe an index on ALLTRIM will not be used for Rushmore optimization.

HTH,

>I have an SQL command:
>
>SELECT IDNUM FROM CONTDB WHERE UPPER(ALLTRIM(ln)) = 'VOSS'
>
>In VFP8 22 recs returned in .78 secs
>In VFP9 243 recs return in 23.47 secs
>
>The extra records have a blank LN
>
>
>COUNT FOR UPPER(ALLTRIM(ln)) = 'VOSS' shows 22 in both 8&9
>
>I have an index on:
>
>UPPER(ALLTRIM(ln))
>
>Any idea?