- my $npanxx = shift;
- qsearch({ 'table' => 'phone_avail',
- 'hashref' => {
- 'npa' => substr($npanxx,0,3),
- 'nxx' => substr($npanxx,3,3),
- },
- 'extra_sql' => ' and svcnum is not null ',
- });
+ my $latanum = shift;
+ qsearch({ 'table' => 'phone_avail',
+ 'hashref' => { 'latanum' => $latanum, },
+ 'extra_sql' => ' and svcnum is not null ',
+ });