Should the "rownum rank rs" work on the 8.1.5.0.0 release as well? It is giving me an error on the 'rank' qualifier.

I agree with you about adding a date field to the table, but we do not own the table and we are only using it to report the information that we need.

Thanks again for your help.