Selecting data between twodates??

[Ron S]

Hello all I am writing the query to select values between two dates. My query is Select * from Table1 where date_sent between '25-Jul-07 12:00:00' and '01-aug-07 12:00:00' this is not retrieving me any data as there are some entries between those dates in the table. i had tried using >=25-Jul-07 and <=02-aug-07 ' but this is fetching me 25th and 26th july data which is not supposed to be happened. did i miss something which is very important in the query. thanks in advance.

Bharath.S Ron

[Blue_Boy]

Select * from Table1 where date_sent >= convert(varchar, (convert(datetime,'25-Jul-07 12:00:00')),102) and date_sent <= convert(varchar, (convert(datetime,'01-aug-07 12:00:00')),102)

---

I Love SQL