I am trying to create a query that will find numbers starting with a certain location zone, and ending with a certain location zone.
Data-
925-266-161
912-274-010
925-176-010
I need the query to gather data that starts 903-913 and ends in 010, like 903-xxx-010 to 913-xxx-010. Then the query will only pull those items like the 912-274-010 listed above.
Any suggestions? I tried Between "903-999-010" And "913-999-010" but I received answers ending in '030'
Data-
925-266-161
912-274-010
925-176-010
I need the query to gather data that starts 903-913 and ends in 010, like 903-xxx-010 to 913-xxx-010. Then the query will only pull those items like the 912-274-010 listed above.
Any suggestions? I tried Between "903-999-010" And "913-999-010" but I received answers ending in '030'