Don't convert your dates to string - convert your strings to dates. As of right now you're comparing string values (where '02/01/2007' >'01/28/2008').
you want:
SELECT * FROM [MyDateTable]
WHERE StartDate
BETWEEN cast('02/01/2007' as datetime)
AND cast('01/04/2008' as datetime)
of course - you can also let T-SQL do the implicit conversion for you with:
SELECT * FROM [MyDateTable]
WHERE StartDate
BETWEEN '02/01/2007' --this gets converted to a date
AND '01/04/2008' --this gets converted to a date
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?