Can anyone please help.... i have a SQL 2000 database... i am searching for dates in a SQL select. ie

SELECT * FROM Tbl WHERE ID = 12 AND StartDate = 12/02/2005

But even through SQL query analyzer, it returns 0 results, even though there is records that meet this criteria... I know it is summit to do with the Date, but cant figure it out... The startdate field is in Date/Time Format in sql... Can anyone give me an idea on why this doesnt work

Cheers

use the CONVERT function to avoid any ambiguity:
SELECT * FROM Tbl WHERE ID = 12
AND StartDate = CONVERT(datetime, '12/02/2005', ?)
- see I don't know what to put at the end, coz I don't know whether your date is supposed to be 12 Feb 2005, or 2 Dec 2005...

hth
Phil

One of these might work:
Style ID Style Type
0 or 100 - mon dd yyyy hh:miAM (or PM)
101 - mm/dd/yy
102 - yy.mm.dd
103 - dd/mm/yy
104 - dd.mm.yy
105 - dd-mm-yy
106 - dd mon yy
107 - Mon dd, yy
108 - hh:mm:ss
9 or 109 - mon dd yyyy hh:mi:ss:mmmAM (or PM)
110 - mm-dd-yy
111 - yy/mm/dd
112 - yymmdd
13 or 113 - dd mon yyyy hh:mm:ss:mmm(24h)
114 - hh:mi:ss:mmm(24h)
20 or 120 - yyyy-mm-dd hh:mi:ss(24h)
21 or 121 - yyyy-mm-dd hh:mi:ss.mmm(24h)
126 - yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
130 - dd mon yyyy hh:mi:ss:mmmAM
131 - dd/mm/yy hh:mi:ss:mmmAM

Thanks for the reply guys...
I am using DD/MM/YYYY
The value passed is a querystring value (Using ASP), which is called DateString.. The field is a datetime field

I have this now, but still nothing is being returned:

SQL = "SELECT * FROM Meta_Default WHERE ID = 14 AND StartDate = CONVERT(datetime, '" & trim(DateString) & "', 103)"

Anyone got any ideas now

Cheers

Forget the last post guys, i have it sorted.. Thanks very much for your time and effort, true gents :o)

thanks