Posted by roblowein on 06/19/07 13:45

On 19 Jun, 12:56, Razvan Socol <rso...@gmail.com> wrote:
> Hello, Rob
>
> Try something like this:
>
> SELECT * FROM YourTable
> WHERE DATEPART(hh,StartDate) BETWEEN 8 AND 18
> AND (DATEPART(w,StartDate)+@@DATEFIRST)%7 BETWEEN 2 AND 6
>
> Razvan

Thanks to you both....

A lot of help..

Regards

Rob

[Back to original message]