SQL -- select rows based on comparing 2 dates

I have a table with rows with these fields:

        Emplid
        Start Date (could be any date in the past)
        Termination Date (it's in the year 2000)

I am using using SQL+, and I want to select rows only if the Termination Date is prior to the date in 2000 that corresponds to the Start Date. For example, if the Start Date is 8/1/1970 and the Termination Date is 7/1/2000, then select the row because 7/1/2000 is before 8/1/2000.

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 19:39:31 CDT