Hi,
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