关于ACCESS选择查询 查询首字母
查询条件：LastName以A-M开头的雇员
不会设置阿~~~
怎么写条件阿
参考答案:设你有一个表叫TABLE 里面有一个字段为LASTNAME
Select * From table where LastName LIKE "A-M%" (查以"A-M"开头的)
Select * From table where LastName LIKE "A%" OR LastName LIKE "M%" (查以"A"或"M"开头的)
select * from table where left(lastname,1) <="M"
(查以首个字母为"A"-"M",里面包括了"A","B","C"..."M"字母开头的LASTNAME.