Transact SQL Filtering and Using Predicates

Reminder on SQL Filtering and Predicates.  I use this to help myself remember syntax when first writing scripts.  After I have written the scripts, I save them for later to modify.

Search Condition:

https://docs.microsoft.com/en-us/sql/t-sql/queries/search-condition-transact-sql

Transact SQL where:

https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql