ACCESS查询代码:
Select * from a where name like '*b*'
Sql Server查询分析器的代码:
Select * from a where name like '%b%'
总结:SQL是‘%’和‘_’
ACCESS是‘*’和‘?’
Select * from a where name like '*b*'
Sql Server查询分析器的代码:
Select * from a where name like '%b%'
总结:SQL是‘%’和‘_’
ACCESS是‘*’和‘?’