On 25/11/11 10:34, Eriovaldo Andrietta wrote: > I have this: > 1:002:3:04:xyz:5:777:67:000:11 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? Or do you just want to split a (non first normal form) string into constituent parts? For example : Select <stuff> from <table> where <a column> in split_my_string(..) 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