getting different results with dates

[jaiser123]

m using ms sql server 2005

when i fire query

select * from .............
.......................
.......................
and convert(varchar,login_date,101) = '03/24/2009'

for the dates from '03/24/2009' to 04/10/2009

ie i fire explicit query for each date
and add all the results , then count is 107

but if i fire query

select * from .............
.......................
.......................
and convert(varchar,login_date,101) >= '03/24/2009'
and convert(varchar,login_date,101) <= '04/10/2009'

i get only 41 results

why the two query results differ so much ,
the results should be same

[skhanal]

Do you have DISTINCT anywhere in SELECT?.

You are converting date to VARCHAR, you may want to do it other way round, converting literal string to compare with login_date.