Continue From Thread - 1
Select useremail from birthmail where dob =(select convert(varchar(20),getdate(),1) as expr1)
this query will not work ie: if the birthDate in DB is like this
birthdate = 4/28/1984 12:00:00 AM
so currentDate is = 4/28/2010 12:00:00 AM
if you run the query it will not show that record.. ?