Oracle SQL "IN" Clause - What's the proper Syntax/Format?

Alas, the query is such that your list of strings is not treated as a list at all. It is treated as a single value.

Using your first try as an example: colum2 IN (“2739,2740,4096”)

Each of the variations you tried are each getting treated as though the entire string is enclosed in quotes.

See the following for additional detail. You might be stymied. :frowning:

[URL]Questions