查车牌的SQL语句

[downkey]

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

[rockswj]

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

[google1106]

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

你少了4处引号

[thomas_cat]

用QuotedStr()方便点，多加点很容易晕啊

[feeling_68]

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

或

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum=QuotedStr('粤Z.'+trim(edit4.text)+'港')'
你再试试看。

[chenylin]

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

[ls2008]

ADOQuery1.SQL.Text:='select * from basicdata where cncarnum='''+'粤Z.'+trim(edit4.text)+'港'+''''
暈倒~~不麻煩嘛

[lxhong1980]

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