>>>>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.
>
>I didn't mark anybody's answer with anything. I wonder who does that.

May be one of your hands didn't know what another hand did? :)