Re: Pasring a street address field for an SQL search
| From: | Zak Greant | Date: | Tue, 22 Aug 2000 18:15:15 +0000 |
| Subject: | Re: Pasring a street address field for an SQL search | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-2043@lists.php.net to get a copy of this message | ||
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 StreetIn 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