Re: extract numeric part from address
Date: Tue, 10 Feb 2004 08:50:04 -0800
Message-ID: <uJudnZ-bbbCtl7TdRVn-jA_at_comcast.com>
Hello David,
In case if number always located at the beginning of the filed and space
delimited , you can use below:
select substr(address, 1, instr(address,' ',1) ) from <table>;
If not, then you can use PL/SQL to scrub the address.
Regards,
Ron
"David Chang" <chang_dj_at_yahoo.com> wrote in message
news:8a1Wb.209671$Rc4.1720145_at_attbi_s54...
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html
> I am trying to do some analysis on customer's locality, so I'd like to
> extract numeric part from address.
>
> Here is how the table looks like
>
> Table Member
>
> first_name last_name address1 address2
> state zip
> ======= ======= =================== ===== === ===
> Tom whatever 1200 Evelyn Ave, #121
> CA 94102
>
> What I want to do is to write some sql to extract 1200 from Tom's
address1.
appreciated
> !!
>
> David
>
>
Received on Tue Feb 10 2004 - 17:50:04 CET