Trimming SQL

From: Chris Forlano <cforlano_at_nortelnetworks.com>
Date: Wed, 22 Sep 1999 12:31:58 +0100
Message-ID: <37E8BE2E.33D390EB@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 - 06:31:58 CDT