求SQL中文模糊查询语句

[shadelin]

<%
where_clause="where"
if name <> "" then
where_clause=where_clause & " name like " & name
end if

sqlstr="select * from customer " & where_clause & " order by id"
set data_article=common_connection.execute(sqlstr)
%>

name的值是中文时
上述代码报错：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] WHERE 子句语法错误。

SQL模糊查询不支持中文？还是格式有错误。
谢谢！

[lstup]

你这叫模糊查询？

[xuStanly]

where_clause=where_clause & " name like '%" & name & "%'"

[lstup]

select * from [table] whre name like '%"&name&"%'

[fcuandy]

<%
where_clause=""
if name <> "" then
where_clause=where_clause & " and [name] like '%" & name & "%'"
end if

sqlstr="select * from [customer] where 1=1 " & where_clause & " order by id"
set data_article=common_connection.execute(sqlstr)
%>

[hbhbhbhbhb1021]

你的那上面where前面少了一个空格