select * from table where id like '%ed

select * from table where id like '%edit1.text%'怎么用？(50分)<br />我的代码如下：
with adoquery do
begin
close;
sql.clear;
sql.add('select * from bm where id like '%edit1.text%' );
sql.add('and name like '%edit2.text%'');
open;
end;
调试不通，是什么原因呢？

改成下面的:
with adoquery do
begin
close;
sql.clear;
sql.add('select * from bm where id like '+''''+'%'+edit1.text+'%'+'''');
sql.add('and name like '+''''+'%'+edit2.text+'%'+'''');
open;
end;

一个试验：
s1:='ABC';
s2:='fno like ';
s3:=s2+'+s1+'; ='fno like +s2+';
s3:=s2+''+s1+''; ='fno like abc';
s3:=s2+'''+s1+'''; ='fno like '+s2+'';
s3:=s2+''''+s1+''''; ='fno like 'abc''; 符合SQL要求。
你应该知道怎么做了吧.

with adoquery do
begin
close;
sql.clear;
sql.add('select * from bm where id like '+''''+'%'+edit1.text+'%'+'''');
sql.add('and name like '+''''+'%'+edit2.text+'%'+'''');
open;
end;

谢谢帮忙 调试通过。