查车牌的SQL语句

Question

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='''+粤Z.+trim(edit4.text)+港+'''';
我想让用户只输车牌号码中间的字符前后固定的就不用输了，这条SQL报错？

Answer 1

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum=''粤Z.'+trim(edit4.text)+'港''';

Answer 2

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+#39+'粤Z.'+trim(edit4.text)+'港'+#39;

Answer 3

引号的问题ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+'粤Z.'+trim(edit4.text)+'港';

Answer 4

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='%粤Z.' + trim(edit4.text) + '港%' ';

Answer 5

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+''''+'粤Z.'+trim(edit4.text)+'港'+'''';

Answer 6

晕啊.........
ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='+quotedstr('粤Z.'+Trim(edit4.text)+'港')+';quotedstr函数用来給一个字符串加上引号.

Answer 7

adoquery1.sql.text:='select * from basecdata where cncarnum=''''+'粤Z.'+
                                        trim(edit4.text)+'港'+'''';

Answer 8

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum=''粤Z.'+trim(edit4.text)+'港''';