Edit

Share via

Select rows that don't match a value (Visual Database Tools)

Applies to: SQL Server

To find rows that don't match a value, use the NOT operator.

Find rows that don't match a value

  1. If you haven't done so already, add the columns or expressions that you want to use within your search condition to the Criteria Pane (Visual Database Tools).

  2. Locate the row containing the data column or expression to search, and then in the Filter grid column, enter the NOT operator followed by a search value.

For example, to find all the rows in a 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%'

Related content