USE pubs
GO
SELECT notes
FROM titles
WHERE notes LIKE '50%% off when 100 or more copies are purchased' 
   ESCAPE '%'
GO

<test_expression> BETWEEN <begin_expression> AND <end_expression>
下面的語句用來查找書籍的價格在$20到$30之間的所有記錄。
SELECT   price, title
FROM     titles
WHERE    price BETWEEN 20.00 AND 30.00
GO

SELECT   price, title
FROM     titles
WHERE    price NOT BETWEEN 10.00 AND 40.00
GO

下面的語句用來查找作者姓氏在“del Castillo”到“Hunter”之間的所有記錄：
SELECT   au_lname
FROM     authors
WHERE    au_lname BETWEEN 'del Castillo' AND 'Hunter'
GO

IS NULL關鍵字使用一個查詢條件來查找空白行。在下例中，將查找書籍名稱中advance沒有內容的所有記錄。
SELECT   title , advance
FROM     titles
WHERE    advance IS NULL
GO

IS NOT NULL的用法與IS NULL相同，但是意義相反。
SELECT   title , advance
FROM     titles
WHERE    advance IS NOT NULL
GO

IN關鍵字用來進行子查詢，它的語法：
<test_expression> IN (<subquery>)
或者
<test_expression> IN (<list of values>)
實例代碼：
SELECT   job_id , job_desc
FROM     jobs
WHERE    job_desc IN ('Operations Manager', 
                      'Marketing Manager',
                      'Designer')
GO

下面的實例應用了兩次IN關鍵字：
SELECT   fname, lname , job_id --uter query
FROM     employee
WHERE    job_id IN ( SELECT job_id    --Inner query, or subquery
                     FROM   jobs
                     WHERE  job_desc IN ('Operations Manager',
                                         'Marketing Manager',
                                         'Designer'))
GO

IN關鍵字往往可以加上NOT操作。實例如下：
FROM     publishers
WHERE    state NOT IN ('MA',
                                          'NY')
GO

下列語句用來查看ANSI nulls的狀態：
sp_dboption "pubs", "ANSI nulls"
GO

如果 ANSI nulls被設置成OFF，則可以通過下面的語句改變設置。
sp_dboption 'pubs', 'ANSI nulls', TRUE
GO

EXISTS (<subquery>)
實例代碼：
SELECT   au_fname, au_lname
FROM     authors 
WHERE    EXISTS (SELECT au_id
                 FROM   titleauthor
                 WHERE  titleauthor.au_id = authors.au_id)
GO