>>Hi Michel
>>
>>try
>>
>>where datepart(hour,Client.End) = 12
>
>Yes, that works. But, I have seen a lot of samples on the net with the other syntax. I am wondering if this is deprecated support.

mentioned in SQL2014 here

http://msdn.microsoft.com/en-us/library/ms174420.aspx

so I would think not.