SQL - BETWEEN Operator with Text Value Example

The following SQL statement selects all products with a ProductName beginning with any of the letter BETWEEN 'C' and 'M': Example SELECT * FROM ProductsWHERE ProductName BETWEEN 'C' AND 'M'; Try...

SQL - BETWEEN Operator with IN Example

The following SQL statement selects all products with a price BETWEEN 10 and 20, but products with a CategoryID of 1,2, or 3 should not be displayed: Example SELECT * FROM ProductsWHERE (Price BETWEEN 10 AND 20)AND NOT CategoryID IN (1,2,3); Try...

SQL - NOT BETWEEN Operator Example

To display the products outside the range of the previous example, use NOT BETWEEN: Example SELECT * FROM ProductsWHERE Price NOT BETWEEN 10 AND 20; Try...