Sorry about the late reply but this might form the basis for a birthday check.

SELECT *, AS DaysIntoYear FROM Employees

WHERE ((DATEPART("dy",Birthdate)-DATEPART("dy",GETDATE())) > 0

AND (DATEPART("dy",Birthdate)-DATEPART("dy",GETDATE())) < 15);

Apologies if the...

Bryan - Hi

If I've understood your design problem correctly, I'd allow a 1:M relationship between the Demographic table and the Address table, but add a Flag to the Address table...