Transform text for IN clause?

Greetings,

I have a text variable A = 't1:t2:t3' that I would like to use in the SQL IN clause (i.e. SELECT * FROM X WHERE c IN (A);).

I tried REPLACE and TRANSFORM with no success. For example IN (REPLACE(a,':',''',''')).

Is there a way to do this directly in the SQL statement and not using PL/SQL or VB?

TIA Received on Wed Mar 09 2005 - 07:16:54 CST