Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line from table
Message
 
 
To
12/10/2005 15:17:58
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01058420
Message ID:
01058427
Views:
12
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform