IN statement using a string

[crystalhelp]

I have a string that contains values seperated by commas. I want to use these values in my IN clause.

This is what I mean:

to simplify

branch_string char(10);
branch_string := '1,2,3,4';
select * from branch where branch_id in (branch_string);

How can I do this?

Thanks in advance.

 

[ManjulaMadhu]

Try this:

select * from branch where exists
(select instr(branch_string,branch_id) from branch)

 

[nme]

You could use dynamic SQL:

branch_string char(10);
branch_string := '1,2,3,4';

EXECUTE IMMEDIATE 'select *
from branch
where branch_id in (' || branch_string || ')';

 

[rcurva]

Or,

-- existing
select *
from branch
where INSTR(branch_string, branch_id) > 0;


-- not existing
select *
from branch
where INSTR(branch_string, branch_id) = 0;

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War