On 25/11/11 12:26, Norman Dunbar wrote: > Are you looking to be able to treat the result of such a split as a > "table" so that it can be used in an IN or similar? If the above, have a look here: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425 Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l