Hi,

I need to specify the IN condition for an SQL during runtime.
The other part of the SQL is static.

However, doing the below doesn't even seem to work.

SELECT * FROM users
WHERE login IN ('user1' || ',' || 'user2')

The string "'user1' || ',' || 'user2'" is built and set during runtime.

Anyone has any idea why it doesn't work.
Please advise.

Thanks.