T-SQL 101: #23 Combining multiple WHERE clause predicates with AND, OR, and NOT in SQL Server

added by DotNetKicks
7/30/2019 12:30:23 PM

1 Kicks, 143 Views

WHERE clauses can have more than one predicate. In the case shown above, I'm saying "where the description starts with hydro and not size equals 370ml" The operators AND, OR, and NOT can be used to form a group of logical decisions that need to be made.