query1.close; query1.sql.clear; query1.sql.add('select * from table where field like 'zz%''); query1.open;
select * from table where field like '%aa%'
var zz:string zz:=trim(edit1.text); query1.close; query1.sql.clear; query1.sql.add('select * from table where field like 'zz%''); query1.open
如果aa是一个edit的值,该怎么办???
query1.sql.add('select * from table where field like '+''''+'%'+edit1.text+'%'+'''');
query1.ParamByName('aa').AsString:=Edit.Text;
query1.sql.add('select * from table where field like '+''''+'%'+Trim(edit1.text)+'%'+'''');
%aa: 左边为任意字符 aa%: 右边为任意字符 %aa%:左右为任意字符query1.sql.add('select * from table where field like% '+''''+Trim(edit1.text)+'%'+'''');
query1.Active:=False; query1.sql.clear; query1.sql.add('select * from table where field like "%zz%"');//某些后台可用双引号 query1.sql.add('select * from table where field like ''%zz%''');//不行就用这句 query1.Active:=True;
query1.close; query1.sql.clear; query1.sql.add('select * from table where field like ' + quotedstr('%' +edit1.text + '%'); query1.open;
query1.sql.add('select * from table where field like '+''''+'%'+edit1.text+'%'+'''');
在SQL Server书中有资料显示,你为什么不先翻翻书再问呢? 弱智
query1.sql.add('select * from table where field like ''%'+edit1.text+'%'');
select * from table where field like '%aa%'
query1.sql.add('select * from table where field like ''%'+edit1.text+'%''');
query1.sql.clear;
query1.sql.add('select * from table where field like 'zz%'');
query1.open;
zz:=trim(edit1.text);
query1.close;
query1.sql.clear;
query1.sql.add('select * from table where field like 'zz%'');
query1.open
aa%: 右边为任意字符
%aa%:左右为任意字符query1.sql.add('select * from table where field like% '+''''+Trim(edit1.text)+'%'+'''');
query1.sql.clear;
query1.sql.add('select * from table where field like "%zz%"');//某些后台可用双引号
query1.sql.add('select * from table where field like ''%zz%''');//不行就用这句
query1.Active:=True;
query1.sql.clear;
query1.sql.add('select * from table where field like ' + quotedstr('%' +edit1.text + '%');
query1.open;
弱智