Using RateCenterInfo - Latest

This section explains how to use MapInfo Pro to query the RateCenterInfo database and generate a list of the NPA/NXXs within a specific rate center.

1. Open all of the RateCenterInfo tables (rcd_usa, rcg_usa, and rcp_usa or; rcd_can, rcg_can, and rcp_can).
2. Click Query > Select to open the Select dialog box.
3. Choose the rcd_ table from the Select Records from Table drop-down list.
4. Click the Assist button. This will bring up the Expression dialog:
   
   

   

   
   
5. Select RATE_CNTR from the Columns drop-down list.
6. Select = (equals) from the Operators drop-down list.
7. Type the name of the rate center in quotation marks, as shown in Figure 2.
8. Click Verify to confirm that the query was entered correctly.
9. Click OK to return to the Select dialog.
10. Check the Browse Results box and click OK.

MapInfo Pro will open a new browser window that displays the results of your query: