Filtering on Date Values

Transact-SQL
7

If this is true:
OR
(dbo.SO_SalesOrderHeader.OrderType = 'B')
then the row will be selected regardless of the other conditions, because of the "OR".