>Thanks, Naomi
>That looks good.
>I found this too- it strips the time off
>:
> CAST(FLOOR(CAST(mydatetimecolumn AS float))AS datetime)

I don't know where you found it, but forget it right away. Don't ever try to use function on the field - it will make your query non-sargable.

Please make sure to read the short blog by Aaron Bertrand I referenced (the second reference).