>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

SET CENTURY 99 ROLLOVER 85

lcString = "999-99-00001"

lcPart1 = LEFT(lcString, 3)

lcDatepart = DTOS(ctod("12"+"/"+"31"+"/"+SUBST(lcString, 5,2)))

lcPart3 = right(lcString)

lcString = lcPart1+lcDatePart+lcPart3