Filtering Records by NULL Values
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL in a T-SQL statement.
Filtering Records
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Filtering Records by Dates and Times
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
Filtering Records by Character Data
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.