I apologize, I did not state my need clearly...

I know that you can do a datediff on the years to get the birthdate...But that is not entirely accurate

Case in point:

If my birthday is in December (12/12/1983) and I just did the datediff function using getdate() and that birthdate...It would return that my age is 29 when really I would still be 28! That is why I have all those if statements! Because those account for those situations!

And with it being a scalar function, it is running way slow! Was just wondering if there was a different way to go about it and be as accurate!