Re: SQL Between Dates

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@xxxxxxxx> wrote in message
news:eipfg21v7lgkd3nk8fg5ulg1jfou2ah43l@xxxxxxxxxx
On Wed, 13 Sep 2006 11:59:46 +0100, "@sh" <spam@xxxxxxxx> 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


.