Re: Trimming SQL

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Wed, 22 Sep 1999 14:08:27 +0100
Message-ID: <4z4G3.55$2r3.3421@newreader.ukcore.bt.net>

How about something like

select ..... substr(col1,instr(col1,' ')+1,length(col1)-instr(col1,' '))

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Chris Forlano <cforlano_at_nortelnetworks.com> wrote in message news:37E8BE2E.33D390EB_at_nortelnetworks.com...
> Looking for and update statement that can trim the following:
>
> col1
> -----
> '0001 text1'
> '0002 text2'
> '0003 text3'
>
> ... into this ...
>
> col1
> -----
> 'text1'
> 'text2'
> 'text3'
>
> Essentially, remove all text preceding the first space.
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>
Received on Wed Sep 22 1999 - 08:08:27 CDT