Hi,

I use the following and have found it really easy and reliable:

CAST(FLOOR(CAST(GETDATE() AS FLOAT))AS DATETIME)

Cheers

Perfect!!!

Thanks Andras, Ireally appreciate the help