All, I am wondering if there is an oracle sql call that would split a character field content -ex abc:xyz:def should return abc xyz def
Could do it in remedy but was looking to get in one call. Thanks Atul _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"