Specifies the search condition for the rows returned by a DELETE, MERGE, SELECT, or UPDATE statement in SQL Server 2008 R2. Use this clause to limit the number of rows returned by or affected by the statement.
The following examples show how to use some common search conditions in the WHERE clause.
A. Finding a row by using a simple equality
USE AdventureWorks2008R2; GO SELECT ProductID, Name FROM Production.Product WHERE Name = 'Blade' ; GO
B. Finding rows that contain a value as a part of a string
C. Finding rows by using a comparison operator
D. Finding rows that meet any of three conditions
SELECT ProductID, Name FROM Production.Product WHERE ProductID = 2 OR ProductID = 4 OR Name = 'Spokes' ; GO
E. Finding rows that must meet several conditions
SELECT ProductID, Name, Color FROM Production.Product WHERE Name LIKE ('%Frame%') AND Name LIKE ('HL%') AND Color = 'Red' ; GO
F. Finding rows that are in a list of values
SELECT ProductID, Name, Color FROM Production.Product WHERE Name IN ('Blade', 'Crown Race', 'Spokes'); GO