CODEWITHSUNDEEP
sqlexcelodbc
sephiith
sephiith

Reputation: 1197

SQL missing operator error

What is wrong with the below line of SQL

Relevant line:

SELECT * 
  FROM glossary.csv 
 WHERE source NOT IN ('AIS','AIP','ICAO','WATOG','ICAO/AIP') 
  AND NOT LIKE('CASR%')"

Error: 

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression 'source NOT IN ('AIS','AIP','ICAO','WATOG','ICAO/AIP') AND NOT LIKE('CASR%')'.

/junk/glossary.asp, line 20

Upvotes: 0

Views: 849

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300728

You missed out the column name in the second part of the where clause:

"SELECT * FROM glossary.csv 
 WHERE source NOT IN ('AIS','AIP','ICAO','WATOG','ICAO/AIP') 
 AND source  NOT LIKE 'CASR%'"

Upvotes: 6

Related Questions