菜鸟菜问：SQL表里的“”与NULL

[yan9299]

我要写个SQL语句，去除表里TYPE为“”和NULL的项。（注：表里TYPE字段里既有值为“”，也有值为NULL）

[xiaoku]

delete from tbl where isnull(type,'')=''

[dawugui]

select * from tb where col = '' or col is null

[dawugui]

select * from tb where type = '' or type is null

[-狙击手-]

delete   
from   tbl   
where   isnull(type,'')=''

[netcup]

乌龟写的检索

delete from tb where col = '' or col is null

[威尔亨特]

delete from tb where col = '' or col is null