>Table Name: Member >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 >There are many deleted records? You can try adding another tag:
>SQL: >SELECT Card_no, Name, Address ; >FROM Member ; >WHERE Card_NO = tcCardType ; >INTO CURSOR mymember >As you have an index on Card_no, it will be optimized, and you'll have the same results if you have SET EXACT OFF.