高手请看一下like语句错在何处解决办法

高手请看一下like语句错在何处
Adodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行%' and name LIKE '% & Text1.Text & %'"

dim ss as string

Adodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行%' and name LIKE '% ss %'"

这2句like 模糊查询错在何处？多谢



[解决办法]

VB code

'name是系统保留字，要用方括号括起来Adodc1.RecordSource="SELECT * FROM info WHERE [name] LIKE '银行%' and [name] LIKE '% ss %'"
[解决办法]
Select * from info where name like '银行%' and '%ss%'