Guys pls help me in writing this query using CASE's .

emp_id status date
1 A 2000-01-01
2 A 2001-01-01
3 A 2002-01-01
4 A 1999-01-01
5 A 1998-01-01
6 I 2004-01-01
7 T 1995-01-01

If Status is NOT equal 'A' select the emp_id
If Status is equal 'A' select the emp_id only when DT>='2000-01-01'

case when status = 'A' then case when dt >= '2000-01-01' then emp_id else null end else emp_id end

Andy