anitra_tanner_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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Mar 14 2007 - 21:05:18 CDT
