select coalesce( fsl_choId, 0 ) fsl_choId, operatorId, companyName, address, city, state, zipcode, recordSource from tbl_OPR_ClientOperators with (nolock) where ownerId = #url.libOwnerId# and fsltablecode = '#url.libOwnerType#' and operatorId = select cho_name, cho_address, cho_city, cho_state, cho_zipcode from tbl_CHO_Operators where cho_id = select companyName from tbl_OPR_ClientOperators with (nolock) where fsl_choId = union all select cho_name as companyName from tbl_CHO_Operators with (nolock) where cho_Id = select 0 as fsl_choId, cho_Id as operatorId, cho_name as companyName, cho_address as address, cho_city as city, cho_state as state, cho_zipcode as zipcode, '' recordSource, 0 as score, '' cdr_dstName, '' cdr_dstCity, '' cdr_dstState, cho_id as mfrCustNum from tbl_CHO_Operators opr with (nolock) where cho_id = select 0 as fsl_choId, cho_Id as operatorId, cho_name as companyName, cho_address as address, cho_city as city, cho_state as state, cho_zipcode as zipcode, '' recordSource, 0 as score, '' cdr_dstName, '' cdr_dstCity, '' cdr_dstState, cho_id as mfrCustNum from tbl_CHO_Operators opr with (nolock) where ( ( 1 = 2 or opr.cho_Id = ) or ( ( 1 = 2 or opr.cho_name like '%#rereplaceNoCase( _w, "s$", "" )#%' ) and ( cho.cho_name like '%#_firstWord#%' ) and cho_state = ) ) and opr.cho_name like and opr.cho_address like and opr.cho_city like and opr.cho_zipcode like and opr.cho_state like select opr.fsl_choId, opr.operatorId, opr.companyName, opr.address, opr.city, opr.state, opr.zipcode, opr.recordSource, 0 as score, cdr.cdr_dstName, cdr.cdr_dstCity, cdr.cdr_dstState, opr.mfrCustNum from tbl_OPR_ClientOperators opr with (nolock) innerleft outer join tbl_CDR_Distributors cdr with (nolock) on cdr.cdr_recordId = opr.distrib1 and cdr.ownerId = opr.ownerId and cdr.fsl_tablecode = opr.fsltablecode where opr.ownerId = and opr.fsltablecode = and ( ( 1 = 2 or opr.fsl_choId = ) or ( ( 1 = 2 or opr.companyName like '%#rereplaceNoCase( _w, "s$", "" )#%' ) and ( opr.companyName like '%#_firstWord#%' ) and opr.state = ) ) and opr.companyName like and opr.address like and opr.city like and opr.zipCode like and opr.state like select * from qmd_operatorsRaw where score > 0 order by score desc, companyName

Looking for...
#filter( "companyName", qmd_operator.companyName )# #filter( "street", qmd_operator.address )# #filter( "city", qmd_operator.city )#, #filter( "state", qmd_operator.state )# #filter( "zipCode", qmd_operator.zipcode )# FSL: #qmd_operator.fsl_choId# #filter( "companyName2", qmd_1fsName.cho_Name)# #filter( "street2", qmd_1fsName.cho_address )# #filter( "city2", qmd_1fsName.cho_city )#, #filter( "state2", qmd_1fsName.cho_state )# #filter( "zipCode2", qmd_1fsName.cho_zipCode )# #htmleditformat( _cleanCompanyName )#
Found #qmd_operators.recordCount#

#htmleditformat( companyName )#^#score#

#htmleditformat( address )#
#htmleditformat( city )#, #htmleditformat( state )# #htmleditformat( zipcode )#
ID:#htmleditformat( mfrCustNum )#
#operatorId# fsl:#fsl_choId#
#htmleditformat( recordSource )#

#htmleditformat( cdr_dstName )#

#htmleditformat( cdr_dstCity)#, #htmleditformat( cdr_dstState )#

Inherit select cho_name, cho_address, cho_city, cho_state, cho_zipcode from tbl_CHO_Operators where cho_id =

#htmleditformat( qmd_cho.cho_name )#
#htmleditformat( qmd_cho.cho_address )#
#htmleditformat( qmd_cho.cho_city )#, #htmleditformat( qmd_cho.cho_state )# #htmleditformat( qmd_cho.cho_zipcode )#

LINK TO THIS FSL RECORD

#htmleditformat( _matchText )# ", "ALL" )> #htmleditformat( _matchText )# ", "ALL" )> #_resultsHTML# #htmleditformat( _w )#