David Lewis
DavidL at sierranevada.com
Thu May 19 13:24:24 CDT 2005
I find the following works well: CONVERT(DATETIME,(CONVERT(varchar,TheDateField,112))) This strips off the time portion and returns the date. I have never perceived any performance hits, but I also haven't done any rigorous comparisons. HTH D. Lewis