2010-01-31 SQL, Access 模糊查询的迥异

1. 任意个字符，都是%. eg.

select * from tblStudents where FirstName like '%Jason'

Micro Jason, M Jason will be selected out.

2. 单个字符

1) SQL 用_. eg.

select * from tblStudents where FirstName like '_Jason'

M Jason will be selected out and Micro Jason won't be selected out.

2) Access 用*. eg.

select * from tblStudents where FirstName like '*Jason'

M Jason will be selected out and Micro Jason won't be selected out.