Posted by Razvan Socol on 06/19/07 11:56

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

• Next in forum: Re: Search: CONTAINSTABLE
• Prev in forum: Re: DateTime
• Thread view: Re: DateTime

[Reply to this message]