trying to match zipcodes for GEO region
Posted by:
Jay Cohen
Date: June 04, 2012 01:54PM
All;
I am sorry if this seems a bit basic. I did search the archives and I don't see any answers.
I have a large mailing list (approx 670,000 records). I am working on the comand line and would like something like this. But not sure I know how to do it.
select zipcode from table where zipcode (this is my problem)
I want to match the first 3 digits to the zipcodes in the database for each town.
I have tried using substring and not sure how to use strcmp and like.
Help me please.
Jay
Subject
Views
Written By
Posted
trying to match zipcodes for GEO region
3848
June 04, 2012 01:54PM
2039
June 04, 2012 02:20PM
2037
June 13, 2012 11:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.