Rosalie - I also display data in reports in month/year format, and select
the data by month and year also. To speed performance, I created another
column in my table, called year_month, which I defined as numeric(6). The
data looks like 199901, 199902. I then put an index on the column to help
searches, and I created an object based on the column which will display it
in a nicer format. I do the sort on the numeric, but display the “nicer”
one. My application is a data warehouse so this denormalizing doesn’t cause
any problems for me.
I hope this helps.
Marian Cooney
McKessonHBOC
Malvern, PA
Listserv Archives (BOB member since 2002-06-25)