Skip to Content
0
Former Member
Mar 26, 2009 at 07:05 AM

variable in IN operator

388 Views

Dear All,

I would like to ask if it is possible to use variable inside WHERE-IN clause.

Say:

SELECT id name INTO TABLE itab FROM table WHERE id IN ('A','B','C').

I would like 'A','B','C' to be in a variable e.g. mytext so that it would be:

SELECT id name INTO TABLE itab FROM table WHERE id IN (mytext).

Thank you very much.

Points will be awarded.

Regards,

Rayel