-
Runtime 'IN' Condition
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|