Ang: RE: sql-important

From: <Roland.Skoldblom_at_ica.se>
Date: Wed, 14 Nov 2001 03:05:59 -0800
Message-ID: <F001.003C44B4.20011114024020@fatcity.com>

Well in should be the the word 'Test today' to be included in the sql statement

"Nicoll, Iain (Calanais)" <iain.nicoll_at_calanais.com>@fatcity.com den 2001-11-14 02:20 PST Sänd svar till ORACLE-L_at_fatcity.com

Sänt av: root_at_fatcity.com

Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:

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


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

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