R Rick Brandt Jul 22, 2005 #2 Heather said: What is the functionality of "<>" ? Click to expand... That is the "not equal" operator. If I wanted a query to return all rows where FieldA does not contain the entry "SomeText"... SELECT * FROM TableName WHERE FieldA <> "SomeText"
Heather said: What is the functionality of "<>" ? Click to expand... That is the "not equal" operator. If I wanted a query to return all rows where FieldA does not contain the entry "SomeText"... SELECT * FROM TableName WHERE FieldA <> "SomeText"