Posted by Roy Harvey on 06/26/07 11:53

What possible value can be BOTH >= AND < the SAME date? You need to
add a day to the second date, make it 6/21.

Roy Harvey
Beacon Falls, CT

On Tue, 26 Jun 2007 10:34:51 -0000, "navneetkasulkar@gmail.com"
<navneetkasulkar@gmail.com> wrote:

>I have a problem in this query:
>
>select order from ordertable
>where orderdate >= '06/20/2007' and orderdate < '06/20/2007'
>
>this query do not return any record
>although there are records in the table matching the query
>
>please help me

[Back to original message]