Re: How to search a string

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sat, 5 Jan 2002 16:43:40 -0600
Message-ID: <u3f0cs6arplob8@corp.supernews.com>

select name1||','||name2 from nametable
where name1 = 'Tweety'
and name2 = 'Bird';

Should give you Tweety,Bird

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

<alien_pt_at_clix.pt> wrote in message news:3c3775cc.6346225_at_news.clix.pt...
> hello
>
> i need using only sql to divide a string by the ', ' for example a
> string like this 'name1,name2' i need to get name1 and name2
>
> thanks
Received on Sat Jan 05 2002 - 16:43:40 CST