(ASP & MSSQL Server 2000) Matching date for query

[msimmons]

I am trying to pull records based on date... the field is date/time and the data is like:
2002-08-12 10:21:13.000

I want to pass it
08/12/2002

but it is not returning any records...
any ideas?
Michael

[msimmons]

I got it. I was doing:
= '08/12/02'
when I should have been doing:
>= '08/12/02'
because of the time stamp "00:01 08/12/02" is greater than just "08/12/02"

Michael