On Mar 14, 3:47 pm, Brian Peasland <d..._at_nospam.peasland.net> 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?
>
> The SUBSTR function can be used to pull out a portion of the string
> similar to the following:
>
> WHERE SUBSTR(zipcode,1,5) = 98765
>
> Additionally, you can use something more like:
>
> WHERE zipcode LIKE '98765%'
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com
Thank You!!
Received on Thu Mar 15 2007 - 07:19:04 CDT
