with query do
begin
close;
sql.clear;
sql.add('select * from table');
sql.add('where ziduan like '+#39+'%'+edit1.text+'%'+#39);
open;
end;
begin
close;
sql.clear;
sql.add('select * from table');
sql.add('where ziduan like '+#39+'%'+edit1.text+'%'+#39);
open;
end;
如果功能很简单,就用通佩符' * '就可以了。
(有些SQL书上说是' % ',但我用了不好使)