That definitely worked as you described, thank you. However, performance is key for us. We'll need to fire off a query like that at a steady 15hz heartbeat (a WHERE NOT IN actually). Could you suggest a faster equivalent to accomplish such a task?
What about dumping the string list into a #TempTable and then firing off a SELECT WHERE NOT IN (SELECT value FROM #TempTable)? R -- View this message in context: http://www.nabble.com/WHERE-SomeColumn-IN-%28%40SQLiteParameter%29-----tp14808093p14813594.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------