Hi
I also use CAST(GETDATE() AS date) ... but it works only for sql server 2008 because in an earlier version date is not a type. Another point of view is...
____________________________________________________________________
Catalin Dumitru
For personal info please visit www.catalin-dumitru.ro