假设用的edit控件如下: select * from 表名 where 字段名 like '+''''+'%"+edit.text+'%'+'''';
with adoquery1 do begin close; sql.clear; sql.add('select * from yourtable '); sql.add(' where yourfield like :yourfield '); parambyname('yourfield').value := yourvalue; open; end;
select * from 表名 where 字段名 like '+''''+'%"+edit.text+'%'+'''';
begin
close;
sql.clear;
sql.add('select * from yourtable ');
sql.add(' where yourfield like :yourfield ');
parambyname('yourfield').value := yourvalue;
open;
end;