In operator without ()

Error 2429

When coding an SQL statement that includes the "IN" operator you must surround the list of items to test with parenthesis. For example, to see if a value is one of a set of values you could code in the WHERE clause of an SQL query:

WHERE Publishers.State IN ('TX', 'CA', 'WA')

This code tests to see if the State Field is either Texas, California, or Washington.