On Mar 14, 10:05 pm, DA Morgan <damor..._at_psoug.org> wrote:
> anitra_tan..._at_yahoo.com wrote:
> > 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?
>
> WHERE LENGTH(zip_code_field) = 5;
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
THank YOu Very MUCH!!!
Received on Thu Mar 15 2007 - 08:17:18 CDT
