One month records only Sql Server 2005 1

[macsql1]

Hi,

I want records for only one month, between 1st January 2007 till 31st January 2007.

I written following query, but output also gives for January 2008 and 2009 using sql server 2005. Kindly help..

select convert(varchar,LastDate,101), * from Table1 where
(convert(varchar,LastDate,101) >= '01/01/2007' and convert(varchar,LastDate,101) <= '01/31/2007')

-Mac

 

[PDreyer]

Don't convert to and compare char data, use

where LastDate>='20070101'
  and LastDate<'20070201'