Re: zip code issue

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?
>

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
dba_at_nospam.peasland.net
http://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 from http://www.teranews.com