Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORACLE SUBSTR FUNCTION HELP
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
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