How to search date converted to nvarchar in sql statement

Question

Dear All,

I want to appreciate this notable community for all the speedy tips they have given to me this increase my learning and development time.

 

i currently have this challenge with my SQL script, i want to extract data between 01-01-2008 and 31-12-2008 the result did not display all data in 2008 but show date from 2010 till 2016. 

 

this my code

 

select * from dtl_patientRegister where left(convert(nvarchar,ARTStartDate,110),10) between '01-01-2008' and '31-12-2008'

 

 still am not getting the expected result, please kindly share with me any other way possible.

 

thank you all