Does this really work ?

SELECT *
FROM USERS
WHERE YEAR(createdDtm) = '2002'

thanks

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

There's no reason why it shoudn't...............correct syntax. Why don't 
you try it out???? ;-)

Joe