Re: how to trim off text

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 23 May 2003 22:25:12 +0200
Message-ID: <8r0tcvgksu5vpm4mv796cq3gu120b2lniu@4ax.com>

On 23 May 2003 11:17:13 -0700, susana73_at_hotmail.com (Susan Lam) wrote:

>I have a varchar2 column have data like below:
>001
>002
>003-ABC
>004-XYZ
>005
>
>I would like to trim off everything after '-', resulting in
>001,002,003,004,005. How do I do that? I tried rtrim but it looks
>like it can only trim off a fix value of text..
>
>Thanks in advance,
>Susan

substr(foo, 1,instr(foo,'-'))

Homework!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 23 2003 - 15:25:12 CDT