I'm looking at a SQL statement on a page i'm working on and the SQL statement is using a IN. I have never seen this done before and its not working correctly. I'm wondering if it is correct and what the syntax for it is.
SELECT * FROM Table WHERE Column_Name IN ('ABC','DEF','GHI')
Each record has within the Column_Name has one of those 3 values or it could have another value and the select wouldn't pick that record.