hey i have used oracle 9i. Am a beginner in msql server 2005. I find some data type issues difficult. Very easy question what is the correct data type for 'YEAR' in msql server. I understand that i can use smalldate data type for date.