I need to select all the records from an audit trail after a key value changes. What I have is like this:

date     time     color
20001001 18:03:12 RED
20001001 18:03:13 PINK
20001001 18:03:14 ORANGE
20001001 18:03:15 TEAL
20001001 18:03:16 GREEN
20001001 18:03:17 YELLOW
20001001 18:03:18 BLACK
20001001 18:03:19 WHITE

I need to select from the green down. I've been doing it like this:

select *, date+time as logkey from audit_trail into cursor stuff
select * from stuff where log_key >= (select log_key from stuff where color = "GREEN")

The problem is that there may be more than one green record, but I need to select all the changes since the first green record. I thought about using TOP, but that doesn't work in a sql select.

Thanks!