How to...retrieve data based on one condition(Kristofer Gafvert, October 11, 2009)
Usually when you want to see data from a table, you do not want all data, but instead data that satisfy a criteria. The following example retrieves addresses from the Person.Address table in the AdventureWorks sample database, where the city is "Bothell".
FROM Person.Address WHERE City = 'Bothell'
Remember that text must be enclosed with apostrophes (� character).
In the above example, the WHERE clause is used to restrict rows returned by the query.
Applies to [?]
SQL Server 2008