select top 50 0 as rowNumber, '2-CHD' as dataset, 'OPR' as partnertype, operatorid as partnerid, companyname, address, address2, city, state, zipcode, '' as priority, 0 as myacctsort from tbl_opr_clientoperators where ownerId = 1 and fsltablecode = and crmactive = 'y' and 1 = 2 and companyname like and zipcode like order by companyname select * from qcf_accounts union select * from qcf_chdResults order by distance asc order by dataset, myacctsort, priority, companyname order by dataset, companyname order by annualCases desc, companyname order by annualCases asc, companyname select * from qcf_accounts where rowNumber <= 10

provide additional search criteria
to view results

no accounts found

add new operator

scan business card

Accounts Near Me Top Ten Distributors #numberformat(_totalOriginalRecords,"9,999")# Found

#iif(client.ownerid eq 26,de('add new operator'),de('new opr'))#

Unprioritized Accounts

#replace(priority,'*','A+')# Priority Accounts

#companyname#

0% #_delta.deltaPercent##_delta.indicatorCharacter# #numberformat(distance,"9.99")# #distanceUOM# #replace(priority,'*','A+')# ERF #address#, #city# #state#, #zipcode#

Acct Num: #_acctCode#

YTD Cases: #numberformat(annualcases,"9,999")#

YTD Dollars: $#numberformat(annualDollars,"9,999")#

Acct Num: #_acctCode#

#_acctDisp#

#currentrow#

#companyname#

0% #_delta.deltaPercent##_delta.indicatorCharacter# #address#, #city# #state#, #zipcode#

The following results are from CHD Data and can be purchased for $1.00 each. Click an entry to preview and optionally purchase.

#companyname#

#address#, #city# #state#, #zipcode#

#_lowerPagerDisplay#