Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORACLE SUBSTR FUNCTION HELP

ORACLE SUBSTR FUNCTION HELP

From: Dave <dchou1108_at_hotmail.com>
Date: 29 Sep 2002 07:11:41 -0700
Message-ID: <8f19196e.0209290611.38cc9b2@posting.google.com>


I am trying to get the city name from an address column of type VARCHAR2(80)

The address looks as follow:
ADDRESS


2800 Montrose Ave. Lacresenta, CA 92832
1231 Fullerton Ave. Fullerton, CA 92898
3301 Huston Ave. Garden Grove, CA 92123

1234 Placentia Rd. Placentia, CA 92871
34 Starbucks Rd. Seattle, WA 43249
1214 Ford Ave. LA, CA 98649
1317 Bond Ave. LA, CA 98649

How do I get the city for the substring. I am trying to group my query by the city.

Thanks Received on Sun Sep 29 2002 - 09:11:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US