Client Results


select cust_id,busname,logoaddress,busdes,bustype_1,web from #tablename1# where bustype_1='#type#' OR bustype_2='#type#' OR bustype_3='#type#' order by busname


select cust_id,busname,logoaddress,busdes,bustype_1,web from #tablename1# where buscat_1='#capability#' OR buscat_2='#capability#' OR buscat_3='#capability#' OR buscat_4='#capability#' OR buscat_5='#capability#' order by busname
#search_by_type.busname#
#left(search_by_type.busdes,400)#
#search_by_cap.busname#
#left(search_by_cap.busdes,400)#