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.

Outcomes