模糊查询问题，请大虾帮忙

[ITFLY8]

问题环境
Access数据库中文版,Asp页面UTF-8版本
搜索中文的时候正常,搜索英文语句正确却搜不到内容
1 select * from lei_product where id is not null and leaguer=false and product like '%HANDKERCHUIEF%' order by ser desc 正常

2 select * from lei_product where id is not null and leaguer=false and product like '%DISPOSABLE%' order by ser desc 搜索没数据
请大虾帮忙，谢谢．
3 在access查询里执行语句这两条都搜不到数据，但第一条在asp中可以实现

[OracleRoob]

select * from lei_product where id is not null and leaguer=false and product like '%HANDKERCHUIEF%' order by ser desc


-->改为


select * from lei_product where id is not null and leaguer=false and product like '*HANDKERCHUIEF*' order by ser desc

[OracleRoob]

select * from lei_product where id is not null and leaguer=false and product like '%DISPOSABLE%' order by ser desc


-->改为

select * from lei_product where id is not null and leaguer=false and product like '*DISPOSABLE*' order by ser desc

[OracleRoob]

--在ADO的sql串中通配符用%：
select * from 表名 where 字段名 like '%'

--在纯Access中通配符用*：
select * from 表名 where 字段名 like '*'