>>In SQL Server 2008 you can use CAST(myDateTimeCol to DATE)
>>
>>Otherwise simply use
>>

>>MyDateTimeCol > '20100101' and MyDateTimeCol < '20111010'

>
>I am still in SQL Server 2005. Thank you.

If so, why did you mark Bill's response as an answer? DATE type was introduced in SQL Server 2008.