The examples, below, are select statement queries for better performance.
Example 1:
> select NPA, telNumber, entity, org from rhdb_NAHist
where NPA = ‘800’ and telNumber = ‘5551212’;
Be sure to enclose the NPA and telNumber values in single quotes.
Example 2:
> select dialnbr from rhdb_CRRepHdr_xxxxx
where dialnbr = ‘8005551212‘;
where xxxxx = RespOrg Name
Be sure to enclose the dialnbr value in single quotes. Format a Dial# (dialnbr field) using exactly 10 digits (10 numerics) without any alphabetic characters and without spaces or dashes in the dialnbr (e.g., 8005551212).