selecting dates that are in a specific year

[andycape]

i'm having problems with the following statement, i want to select all records from a table where the region and the year are specified :

SELECT * FROM ExpenseAnalysis left join Stores on Stores.StoreID = ExpenseAnalysis.StoreID where region = 'regionname' and year(Dateselected) = 2003 order by Store"

the problem seems to be the way i'm selecting the year?

thanx.

 

[bhoge]

hi andycap
I think u have to use Convert(datetime,selecteddate) function for manipulation , i think this works.
Enjoy programming