RE: [PHP-WIN] Pasring a street address field for an SQL search

I can write the SQL... it's parsing the form TO write the SQL that I'm having problems with... Is there a way to parse the data using spaces as a delimiter? kind of like this: parse($fulladdress, " ") if ( $fulladdress_piece2 = "W" or "E" or "S" or "N" ) { $full_address_piece2_temp %= $fulladdress_piece2 } ; if $fulladdress_piece2 = "west" { $full_address_piece2_temp = "w%" } etc. etc. etc. THEN select * from table where address like '$fulladdress_sql_pieced_together' --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer - http://www.lcounty.com Licking County, Ohio, USA 740-349-3631 > -----Original Message----- > From: Zak Greant [mailto:zak@php.net] > Sent: Tuesday, August 22, 2000 2:15 PM > To: Asendorf, John > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] Pasring a street address field for an > SQL search > > > At 01:56 PM 8/22/00 -0400, you wrote: > >Hello All! > > > >NT PHP4 IIS4 M$Access (ODBC) > > > >Trying to figure out how to parse a street address field so > that I can hit > >a database with some options... The form field allows > someone to put in a > >street address... > > > >For instance: 444 West Main Street > > > >The problem I'm running into is that the database *may* have > the address > >listed as 444 W Main St > >OR 444 West Main St. > >OR 444 W. Main Street > > In SQL I can do this > select * from table where address like '444 W% M% S%' > > I am not sure what the equivalent syntax is in Access > > hth, > > zak > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >