AnsweredAssumed Answered

Query Address Locator using LIKE % Selection Statements

Question asked by optimistpark on Feb 2, 2016
Latest reply on Feb 24, 2016 by sbritt-esristaff

Is it possible to bring back a list of addresses using the address locators styles within ArcMap? I need to be able to create a locator using customer street and point data that can perform SQL statements, basically.


Here is an example. I want to take to be able to take the following address:


1234 Main St, Anywheretown, USA 12345


When I start to type the address:


1234 M


I want the returned list to come back as:


1234 Main St, Anywheretown, USA, 12345

1234 Malorie Dr, Anywheresville, USA, 12365

1234 Mitten Ct, Anywhere City, USA 12355


Basically, I want the search of 1234 M to basically act like a sql statement of ADDRESS LIKE '1234 M%'


I hope this makes sense. Thanks for any and all suggestions.