关于模糊查询
~~~~~~~~~~~~~
nr:string;
begin
xm:=Combobox3.Text ;
nr:=edit1.Text;
case Combobox3.ItemIndex of
0,1,2,3,4,5,6,7,8:
begin
sql:='select * from sheb where '+xm+' like '+QuotedStr(nr)+'';
~~~~~~~~~~
请问下怎么才能实现模糊查询,这个方法like和=似乎没有区别!!
谢谢
[解决办法]
要用通配符啊
select * from sheb where xm like 'aa%'
[解决办法]
QuotedStr(nr+' % ')