Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

WHERE (Transact-SQL)

Specifies the search condition for the rows returned by the query.

Topic link icon Transact-SQL Syntax Conventions

[ WHERE <search_condition> ]

< search_condition >

Defines the condition to be met for the rows to be returned. There is no limit to the number of predicates that can be included in a search condition. For more information about search conditions and predicates, see Search Condition (Transact-SQL).

Community Additions

© 2015 Microsoft