Select Rows That Do Not Match a Value (Visual Database Tools)
Applies to: SQL Server
To find rows that do not match a value, use the NOT operator.
To find rows that do not match a value
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.
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
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort: Gedurende 2024 worden GitHub Issues uitgefaseerd als het feedbackmechanisme voor inhoud. Dit wordt vervangen door een nieuw feedbacksysteem. Ga voor meer informatie naar:Feedback verzenden en bekijken voor