--->

Error: #locData.status#

---> 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 select *, cast(partnerid as varchar) + '|' + partnertype as partneridtype from qcf_accounts where rownumber >= #_startRow# and rownumber <= #_endRow#

provide additional search criteria
to view results

no accounts found
(try unchecking "my relationships")
(try searching "all territories")
(try unchecking "near me")
(try adjusting "my relationships" and "near me" selections)

add new operator

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

--->

Accounts Near Me
zipcode: #url.zipcode#
#url.latlong# #numberformat(_totalOriginalRecords,"9,999")# Found

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

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

#companyname#

#numberformat(distance,"9.99")# #distanceUOM##replace(priority,'*','A+')# #address#, #city# #state#, #zipcode#

Acct Num: #_acctCode#

#_acctDisp#

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#