请问大家，SQL语句的Where子句中要是想按照某个字段不等于某个值查询，不等于号怎么写？

[intersun]

请问大家，SQL语句的Where子句中要是想按照某个字段不等于某个值查询，不等于号怎么写？

[BenBenBoy]

!=, <, >, <=, >=

[Ranma_True]

<>

[SarahCla]

<>

[kmcyz]

一个例子：

Dim dbs As Database, rst As Recordset

' Modify this line to include the path to Northwind
' on your computer.
Set dbs = OpenDatabase("Northwind.mdb")

' Select records from the Employees table where the
' last name is King.
Set rst = dbs.OpenRecordset("SELECT LastName, " _
& "FirstName FROM Employees " _
& "WHERE LastName = 'King';")

' Populate the Recordset.
rst.MoveLast

' Call EnumFields to print the contents of the
' Recordset.
EnumFields rst, 12

dbs.Close

[kmcyz]

或Set rst = dbs.OpenRecordset("SELECT LastName, " _
& "FirstName FROM Employees " _
& "WHERE LastName <> 'King';")