>Thanks for your reply Sergey. As always I value your response a lot. I find your syntaxt more difficult to read than my method, but the big question is: Is your way better, i.e., faster than my method?
IMO, it's more readable than yours. Also it has better chances to get optimized and be faster. Small correction though
SET @DateOnly = DATEADD(dd, DATEDIFF(dd, 0, @DateField), 0)
>
--sb--