>hi to All Experts
>i have one table & in this table i have somany records.
>my problem is there is some row is Dispaly "< Null >" value in all fields.
>so how to remove all this row.
>
DELETE FROM mytable
WHERE COALESCE(col1, col2, col3, ..., colN) IS NULL
--sb--