>>>>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? :)
If it's not broken, fix it until it is.
My Blog