对大侠来说忒简单的问题...如果删除表中空的数据？小弟这里先谢了！

[ykuang]

在一个表中有许多空的数据，如：
table1
name,age,company...
张三 29 X电脑公司
25
王五 27 X厂
..
..

（里面有很多这样半截的数据）如果我想用一sql语句删除应如果做呢？我用过delete from table1 where name="" or company="" 可是不行？

[realdigua]

delete from table1
where name='' or company='' or name is NUll or company is Null

[抱朴守拙]

delete from table1
where name='' or company='' or name is NUll or company is Null

[ykuang]

谢谢，分分了！

[272799]

var i:integer;
begin
with query do
begin
if active then close;
sql.clear;
sql.add('select * from XX.db');
sql.add('where name=""');
open;
for i:=1 to recordcount do
begin
delete;
end;
next;
end;
with query do
begin
close;
end;
end;
OK