Matching Dates

wrote
|How Can I match BirthDate With Current Date???Pls Ans me the query ...which is run in my asp.net ...

Your Tag saying "SQL 2005" but in your question you mentioned you need query run in asp.net....A Confusing question, please hereafter ask the question correctly otherwise we can only guess not solve.

let's come..if you need the solution in front end then follow benjymous method

otherwise if you need the solution in sql, look into the following

SELECT * FROM tblPerson WHERE CONVERT(nvarchar(10),BirthDate,101)=CONVERT(nvarchar(10),GetDate(),101)