到”Pettersen”的数据：
SELECT * FROM Persons WHERE LastName BETWEEN ''''Hansen'''' AND ''''Pettersen''''
返回结果:
LastName
FirstName
Address
City
Hansen
Ola
Timoteivn 10
Sandnes
Nordmann
Anna
Neset 18
Sandnes
Pettersen
Kari
Storgt 20
Stavanger
为了显示指定范围之外的数据，也可以用NOT操作符：
SELECT * FROM Persons WHERE LastName NOT BETWEEN ''''Hansen'''' AND ''''Pettersen''''
返回结果:
LastName
FirstName
Address
City 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> | 
