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@lists.mysql.com > From: japr...@raoset.com > 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 > japr...@raoset.com > 616.399.2355 > > > _________________________________________________________________ Windows Live™ Hotmail®:…more than just e-mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_012009