>>I am sure this has been discussed before, but I never paid much attention to the issue... until now, when I need it.
>>
>>From a list of people with birth dates, how do I find out who has a birthday within a certain range of dates - e.g., the current week?
>>
>>I could write some kind of loop, or complex logic, but I suspect there must be some easier way.
>>
>>TIA,
>>
>>Hilmar.
>
>
>select * from mytable where week(mytable.dob)=week(date())

Thanks, but I don't think that will be very accurate - considering that the first week of the year may start on different dates.

Also, "current week" was only an example - I want to have the ability to include an arbitrary date range.