Jason
try
select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
SUBSTR(ADDRESS,1,INSTR(ADDRESS,'',1))
--------------------------------------------------------------------------------
1232 Main
1234 Main
HTH
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission.
> To: mysql@stripped
> From: japruim@stripped
> Subject: grabbing even addresses?
> Date: Mon, 2 Feb 2009 13:27:26 -0500
>
> Hello!
>
> I was wondering if something was possible, I have an excel file right
> now of US mailing addresses, and what I need to do is select all the
> odd numbered addresses on one road, is there an easy way I can do
> that from MySQL? the addresses could contain 3, 4 or 5 numbers per
> addresses such as:
>
> 123 Main
> 1232 Main
> 1233 Main
> 1234 Main
> 12345 Main
>
> and what I want out of those would be:
>
> 1232 Main
> 1234 Main
>
> Any ideas? Thanks for looking! :)
>
>
> --
> Jason Pruim
> japruim@stripped
> 616.399.2355
>
>
>
_________________________________________________________________
Windows Live™ Hotmail®:…more than just e-mail.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_012009
