select * from #testtable
where id is null or name is null or sal is null
union all
select * from #TestTable
where name =''
use column name instead of * ;
and I assume other values can't be empty..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: