[求助] 一个模糊查询问题

jinyo

只知道在窗口输入的精确查询的sql:
比如：

select name, age
from table_name
where name = [forms]![temp]![input name]

请问如何实现对名字的模糊查询？？

jinyo

只知道通配符是*

sunredday

select name, age
from table_name
where name like"*" & [forms]![temp]![input name] &"*"
或
where name like"*" & [forms]![temp]![input name]
或
where name like   [forms]![temp]![input name] &"*"

jinyo

谢谢 sunredday