>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

---

try this:
filter for iif(a<b;between(a,b);!between(b+1,a-1))


ps. in the previous post not all the text was contained because of the < sign