with ADOQuery do
begin
CLOSE;
SQL.CLEAR;
SQL.Add(Format('Select * from address WHERE 姓名 like ''%s'';',['%'+Edit1.Text+'%']))
end;
begin
CLOSE;
SQL.CLEAR;
SQL.Add(Format('Select * from address WHERE 姓名 like ''%s'';',['%'+Edit1.Text+'%']))
end;
调试欢乐多
行不行,你用query analyzer或类似的环境一试,不久可以了?
select * from tablename where fieldname like '%var%';
你是不是忘了加上引号了!