SET CENTURY TO 19 ROLLOVER 30
SELECT * FROM table WHERE BETWEEN(YEAR(CTOD("01-01-"+SUBS(memberid,5,2))),1999,2000)

> I am trying to upgrading my clients's program which was developed 5 years ago. It is a simple membership system.
> Now, the member table contain about 2500 member records. The member id is generated with membership type (3 digit), registration year (2 digit) and 5 digit of sequential no.
> My client ask for a feature that will allow him to query a set of records. Example, from member id 999-99-00001 (members who register in 1999) to
>999-00-000100 (member register in 2000).
> I have a problem to use BETWEEN() or ">" and "<" to query the records. Since "99" is year 1999 and "00" is year 2000. In user mind, "99" is "smaller" than "00". However, application will "think" "00" smaller than "99".
> What should I do to solve it?
>
>Thank you