And the entire list must enclosed parentheses
| 256 | ||
|---|---|---|
|
||
FIGURE 8-16 Searching Pubid with the IN operator
| 257 | ||
|---|---|---|
|
||
Keep in mind that the NOT option can be used with all comparison operators to reverse the operation. For example, if you want to list all customers in states other than California or Texas, you can add the NOT option to the same query, as shown in Figure 8-18. The list now includes all customers in any states except California and Texas.
