select top #_max# companyName, address, city, state, zipcode, operatorId from tbl_OPR_CLientOperators opr where opr.ownerId = and opr.fsltablecode = and opr.crmActive = and ( opr.address like or opr.companyName like or opr.city like or opr.state = or opr.zipcode = ) order by companyName select m.firstName, m.lastName, m.email, m.title, m.fspro_userid, m.cellPhone, m.phone from tbl_FSPro_members m where m.orgId = and m.orgType = and m.ownerId = and m.fsl_tablecode = order by lastName, firstName