i m using SQL server 2005

@ChrisM@Work : this are (50200,50194,50430,50191,1) Record Id

@HanShi Thanks its working

but i wanna extra add distinct for C_recid

I was tried that but the Output will be comes based on ascending order based but i wanna the output come arranged on in() class based.....

Thank you very much

i have data in this format only and i wanna store one date so that why i have mentioned in int datatype of DOB

create table members

(

id int identity,

firstname varchar(30),

lastname varchar(40),

dob int

)

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)

i wanna result...

Thank you