General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only