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

In access you could use * instead of % -----Original Message----- From: Zak Greant [mailto:zak@php.net] Sent: Tuesday, August 22, 2000 20:15 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