>HELLO hilmar
>this is the SQL Statment
>
>"SELECT CONTRNO,ID_NO,SUBNO FROM POSTPAID WHERE ALLTRIM("271120500557") LIKE ALLTRIM(ID_NO) ORDER BY ID_NO INTO CURSOR QUERY1"
>
>i use SYS(3054,11) to see Rushmore Optimization Level & the level is (None)
>how i can make my SQL statment to make Rushmore Optimization Level(full)
>waiting for your reply
>
>Best Reagdrs
>Mazahir
Then, the problem seems to be with the alltrim(). A direct comparison of the fields, as suggested in the other replies you got, can be optimized; an alltrim() is difficult to optimize.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)