Sorry, I clicked enter before ending writing and I didn't realize... :s

HowardW - Thanks for your tip!

Lynn Pettis

Will this:

WHERE cast(DateColumn as DATE) = cast(@DateToFind as DATE);

perform better than this?

WHERE DateColumn >= CAST(@DateToFind AS DATE) AND DateColumn < DATEADD(DAY,1,CAST(@DateToFind AS DATE))

With your suggestion a conversion against all rows of DateColumn will be performed.

Thanks!