The first thing you should do is to not store dates as integers. Store them as datetime. You are going to have to convert your int to a datetime first to ever use it anyway and validation is painless using a datetime datatype. Make it easy on yourself and store your data in the proper datatype.

create table #members

(

id int identity,

firstname varchar(30),

lastname varchar(40),

dob datetime

)

insert into #members(firstname,lastname,dob) values ('Michel','David','19890630')

insert into #members(firstname,lastname,dob) values ('Raja','Kumar','19900625')

insert into #members(firstname,lastname,dob) values ('Rahul','Sundar','19910501')

insert into #members(firstname,lastname,dob) values ('Arun','Edward','19901219')

select * from #members

drop table #members

So now we have a table with birthdates stored as datetime. What have you tried?