|
|
NOT EQUAL (<>)/LESS THAN/GREATER THANSELECT * FROM People WHERE LName <>'Smothers'The SQL Statement above will retrieve ALL fields: SELECT * From the table named People: FROM People With the requirement that the LName is not Smothers: WHERE LName <> 'Smothers' If this is the original table
Your recordset returned would be this:
Other relational operators: < LESS THAN > GREATER THAN <= LESS THAN OR EQUAL >= GREATER THAN OR EQUAL | |||||||||||||||||||||||||||