How do I ignore the time value in a column when runningquery?

[Scooby Doobie Doo]

I have a query SELECT * FROM Inventory WHERE dateentered =
'9/18/2003' that won't run, because it also has a time value in that column,
so of course it's not matching, how do I write that query to ignore time values
and return the rows that match that date?

[Scooby Doobie Doo]

Nevermind, figured it out.

WHERE convert(varchar(10), DATEENTERED, 101) = '03/03/2005'

fixed the problem..

[fidibidabah]

If lowering the characters effects the query for other usage in undesired ways,
you can also do it like:

WHERE dateentered LIKE '%9/18/2003%'

That should select everyone with that date in it, regardless of what's in
front of it or behind it (note the wildcards)