I have following table structure i m using sql 2000
create table mytab (pid varchar(10), a_check char(1), b_check char(1) detail varchar(30))
it has following data
insert into mytab values ('abc1','A','A','good') insert into mytab values ('abc1',null,null,'') insert into mytab values ('abc2','A','B','good') insert into mytab values ('abc2',null,null,'') insert into mytab values ('abc3','A','A','good') insert into mytab values ('abc3','A','B','Fair')
what i want in result those PID where value of both a_check and b_check is not null in all rows
like in above data set i want only pid values to be return is
abc3
i dont want abc1 and abc2 in result as one row of them contains null
Regards
