Hi,
Thank you for your reply.
Here is my table structure

Table Name: Member

Fields:

1. Card_No
2. Name
3. Address
4. Zip Code
...

Indexes:
1. PCard_No                    Card_No                   Primary
2. Card_Type                   LEFT(Card_No, 3)          Regular
3. Card_No                     Card_No                   Regular

SQL:
SELECT Card_no, Name, Address ;
FROM Member ;
WHERE LEFT(Card_NO, 3) = tcCardType ;
INTO CURSOR mymember

The SQL above will return 5,000 records out of 10,000 records from server.

I tried to issue SYS(3024), it tell me it partial optimization (since i SET DELETED ON).

Any ideas?

Thank you