Route Pattern table in SQL

[cplatt01]

What table are the Route Patterns stored in?

[pbarman · Accepted solution]

It is in NumPlan table along with the Phone DNs.

[josegre]

Can I make a search by this field into SQL?

[cplatt01]

Sure! It depends what you want to pull out.

For example, this gives me all my NANP Route Patterns.

SELECT *

FROM NumPlan

WHERE (DNOrPattern LIKE '9.%')