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 mymemberThe SQL above will return 5,000 records out of 10,000 records from server.