getting different results with dates
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