Thank you Michael.

This code does look very elegant and I will try it out tonight. I didn't want the where clause to get too convoluted and this is very sweet.

I should have thought of it that way myself before!


>Kind of funny. This is the exact example that I'm using in my Advanced Query Techniques for SQLTeach in April.
>
>Try this query:
>
>

>SELECT
>	lastname,
>	firstname,
>	birthdate
>FROM
>	employees
>WHERE
>	DATEADD(year, DATEDIFF(year,  birthdate, GETDATE()), birthdate) BETWEEN GETDATE() AND GETDATE()+7
>	OR DATEADD(year, DATEDIFF(year,  birthdate, GETDATE()+7), birthdate) BETWEEN GETDATE() AND GETDATE()+7
>

>
>-Mike