select zipcode_3d as zipcode from tbl_TER_ZipCodeLink zcl with (nolock) inner join tbl_UT_ZipCodes_3D zc with (nolock) on zc.zip3d_id = zcl.zip3d_id where zcl.territoryid in () select top #_maxItems# opr.cho_id as fslOperatorid, opr.cho_name as fslCompanyname, opr.cho_address as fslAddress, opr.cho_city as fslCity, opr.cho_state as fslState, opr.cho_zipcode as fslZipcode, co.operatorid, co.territoryid from tbl_CHO_Operators opr with (nolock) left outer join tbl_opr_clientoperators co with (nolock) on co.ownerid = and co.fsltablecode = and opr.cho_id = co.fsl_choid where coalesce(opr.cho_acctclosed,'0') <> '1' and ( ( opr.cho_name like or opr.cho_city like or opr.cho_zipcode like ) and 1 = 1 ) and left(opr.cho_zipcode,3) in () and opr.cho_type in () order by opr.cho_name
results capped at #_maxItems#.  try refining your
search to narrow results.

  • #fslCompanyname#

    #fslAddress#

    #fslCity# #fslState#, #fslZipcode#

    •
results capped at #_maxItems#.  try refining your
search to narrow results.

no results