I have tableA
I want to display a list of all data in a date range but add in the city/state of the phone1 field.
Phone1 data will look like 7145551212
the matching row in tableB would have
so i suppose I need to first pull out the first 3 digits to match against areacode and then the next 3 digits to match prefix and display the matching city/state in the result.
some help with the code would be great.