Returning records based on dob field 1

[JSMITH242B]

Hi Group,

I need to return records where the age of a person is less than 11.
I have a dob field in my table which I can use with the Now function to return the desired results but I have a problem with defining the SQL statement using this.

Any help much appreciated.

 

[hmckillop]

Something like this might do

select * from mytable
where datediff(yy, DOB, getdate()) < 11


"I'm living so far beyond my income that we may almost be said to be living apart

 

[JSMITH242B]

Thanks hmckillop.
This did the trick