SQL Server 2012
Specifies the search condition for the rows returned by the query.
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 AdventureWorks2012 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
G. Finding rows that have a value between two values