Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help another zipcode delimma
Thanks for the help on the previous question but now I have been
presented with the following issue.
In the same field we have 3 different scenarios
5 digit zip
12345
6 digit zip
12345-
10 digit zip
12345-1311
I want to say give me all the zips that are 5 and 6 digits and where
there is a 6 digit, dont show the
dash (-). so when my query runs they will all look like 5 digit
zips. I have made a seprate query for the 10 digit.
previously I used length(zip) = 5 Received on Thu Mar 15 2007 - 15:35:26 CDT
![]() |
![]() |