RE: sql-important

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Wed, 14 Nov 2001 02:57:42 -0800
Message-ID: <F001.003C4458.20011114022021@fatcity.com>

Roland,

If it is only 'No Info' that you want to keep then the below should do

SELECT decode(field1,'No Info','No Info',

                 ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))))

FROM mxurval;

Cheers

Iain Nicoll

-----Original Message-----
Sent: 14 November 2001 10:00
To: Multiple recipients of list ORACLE-L

Hallo,

How can I do a select statement that creates this:

I have the field1

Jimmy Y1000
Timmy L33333
No Info

and I want the select to give me this:

Jimmy
Timmy
No Info

You see It should still be 'No info' after the select statement.

How can I change this statement?

SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval;

Thanks in advance

Roland S

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nicoll, Iain (Calanais)
INET: iain.nicoll_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------