Posted by @sh on 09/13/06 10:59

For some reason guys my SQL string isn't working and I'm probably doing
something stupid?

SELECT *
FROM sol_session
SELECT *
FROM SOL_Session
WHERE DateGiven > '10/09/2006' AND <
'13/09/2006'

The 'DateGiven' field is a DateTime field, and I can't see quite whats
wrong??

I simply get a Syntax error!

Cheers, Ash

• Next in forum: Re: SQL Between Dates
• Prev in forum: Re: cross server update problem
• Thread view: SQL Between Dates

[Reply to this message]