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 -> zip code issue

zip code issue

From: <anitra_tanner_at_yahoo.com>
Date: 14 Mar 2007 11:50:01 -0700
Message-ID: <1173898201.199526.223170@n59g2000hsh.googlegroups.com> 





HELP  I need help with a zip code issue.  I have a columm zipcode,
that stores the regular 5 digit zip or the zip + 4.;  I need to
seperate the 2 in my where clause.  I cant figure out how to word it
just to get the fields that only have the 5 digit and not the 5 digit
+4.  Any ideas?
Received on Wed Mar 14 2007 - 13:50:01 CDT












Original text of this message













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