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)