Visual Database Tools
Selecting Rows that Do Not Match a Value
To find products table where the values in the product code column begin with a character other than "A," you can enter a search condition such as the following:
NOT LIKE 'A%'See Also
Entering Search Values | Specifying Search Conditions | Specifying Search Criteria | Including or Excluding Rows