CREATE TABLE #birthday (thedate datetime) 
GO 
INSERT INTO #birthday values ('1/30/1941') 
INSERT INTO #birthday values ('2/28/1942') 
INSERT INTO #birthday values ('3/28/1943') 
INSERT INTO #birthday values ('3/27/1950') 
INSERT INTO #birthday values ('8/26/1950') 
INSERT INTO #birthday values ('10/12/1964') 
INSERT INTO #birthday values ('10/13/1947') 
INSERT INTO #birthday values ('10/14/1976') 
GO 

SELECT *
FROM #birthday 
WHERE 
	MONTH(GetDate()) = MONTH(thedate) 
	AND 
	DAY(GetDate()) = DAY(thedate) 
                
drop table #birthday