What result do you get if you use double equal?
SELECT IDNUM FROM CONTDB WHERE UPPER(ALLTRIM(ln)) == 'VOSS'
Einar
>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?
Semper ubi sub ubi.