Share via

How to: Select Rows that Do Not Match a Value

  • Article

To find rows that do not match a value, use the NOT operator.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

To find rows that do not match a value

  1. If you have not done so already, add the columns or expressions that you want to use within your search condition to the Criteria pane.

  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%'

See Also

Concepts

Rules for Entering Search Values

Other Resources

Specifying Search Criteria