Hilmar,

>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?

select * from theTable where date( year( ldStart ), month( dob ), day( dob ) ) between ldStart and ldEnd