Hello all. How in PLSQL do I say I just want the year? This is what I want. In my WHERE clause I usually say PLAN.YEARENDDATE = '31-DEC-2002'. I want all the results where the year = 2002. How do I syntax that? I tried using the LIKE statement but that doesnt understand it for date I guess. Thanks all