SQL staments Search 不会写

dickson

请问 SQL search staments  怎么写？？

我是用 MS ACESS + vb6


strSQL = "SELECT * FROM Suppliers WHERE Sup_ID = '% & txtSupplierID.Text &  '"

有问题

max5007

strSQL = "SELECT * FROM Suppliers WHERE Sup_ID = '% & txtSupplierID.Text &  '"


改成

strSQL = "SELECT * FROM Suppliers WHERE Sup_ID = '＂& txtSupplierID.Text ＆＂＇＂

dickson

max5007 于 25-1-2005 03:49 PM  说 :
strSQL = "SELECT * FROM Suppliers WHERE Sup_ID = '% & txtSupplierID.Text &  '"


改成

strSQL = "SELECT * FROM Suppliers WHERE Sup_ID = '＂& txtSupplierID.Text ＆＂＇＂

soli soli

我要得是 Like %xxxx
我是用 MS ACESS + vb6


strSQL = "SELECT * FROM Suppliers WHERE Sup_ID Like % '＂& txtSupplierID.Text ＆＂＂

怎么写？？

[ Last edited by dickson on 25-1-2005 at 03:58 PM ]

goatstudio

strSQL = "SELECT * FROM Suppliers WHERE Sup_ID LIKE '%" & txtSupplierID.Text & "'"