How to access user profile details in SOL

Dec 8 2008 6:20 AM

I am using profile provider to save the first name, last name, date of birth etc.
Now, I want to find out the age of a person in my storedprocedure.
How can I access the dateofbirth field in SQL (storedprocedure) to calculate the age?
Which table should I use in the database? I have to get the FIRSTNAME as well.
Any help!