Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help another zipcode delimma
Why are you allowing them to enter a 6 digit zip?
You wonder why the zip code is stored with a dash also. Could have one field for the 5 digits and another field for the extra 4 ditits. This would end all the rediculous entries. Need a better design. Be easier to edit as they are entering the data - It is faster!
You could delete the dashes and then just edit the result if it is 9 digits. Why store dashes at all? It is wasted storage space. Should be able to store just the numbers and insert the dash only when it is displayed like a Date.
<anitra_tanner_at_yahoo.com> wrote in message
news:1173990926.295625.113740_at_y66g2000hsf.googlegroups.com...
> 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 Fri Mar 23 2007 - 12:35:37 CDT