|
|
Posted by @sh on 09/13/06 11:24
Ahhhhh sorry for being silly, knew it'd be something obvious, not having a
good week!!!
Is it possible to use BETWEEN for such a SQL statement?
Cheers, @sh
"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:eipfg21v7lgkd3nk8fg5ulg1jfou2ah43l@4ax.com...
> On Wed, 13 Sep 2006 11:59:46 +0100, "@sh" <spam@spam.com> wrote:
>
>> WHERE DateGiven > '10/09/2006' AND <
>>'13/09/2006'
>
> WHERE DateGiven > '10/09/2006'
> AND DateGiven < '13/09/2006'
>
> You need to specify DateGiven for each comparison.
>
> Roy Harvey
> Beacon Falls, CT
Navigation:
[Reply to this message]
|