how to select part of string

sham — Tue, 03 Apr 2007 18:52:37 GMT

In the foll Eg... , I want to select part of the string before numeric. If the first word numeric, want to select 2nd word to before numeric.

O PREMIUM WATER ACH 070228 DIR PAYMENTXXXX YYYYY
94009 NASE PAYMENT 94009 9544537498XXXX YYYYYY
NATIONWIDE INS CUST-AGNT 070312 43000-934483250 AGENT CENTER
Sprint PCS Telcom 070302 0584245200xxxx yyyyy
WEST COAST LIFE INS. PREM. 070228 WC1Z02418843xxxx y zzzz
STATE FARM RO 08 SFPP 08 S 043840zzzz tttt x
THE LIFESTYLE CLUB DRAFT 030507 28802xxxx yyyy
PRIMERICA LIFE INS. PREM MAR,07 000002343Yx y zzzz

I want to be able to select Only

O PREMIUM WATER ACH
NASE PAYMENT
NATIONWIDE INS CUST-AGNT
Sprint PCS Telcom
WEST COAST LIFE INS. PREM.
STATE FARM RO
THE LIFESTYLE CLUB DRAFT
PRIMERICA LIFE INS. PREM

Thanks very much in advance.
Sham

Teradata Forums / Teradata / Teradata Advanced Analytics User Group / how to select part of string / Latest Posts

how to select part of string