>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.
>
>Thanks in Advance
>
>Best Regards
>Mazahir
DELETE FROM YourTable WHERE SomeField IS NULL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.