|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [BU].company_name) FROM [BU] Inner Join BU_A1 ON [BU].ID = BU_A1.Referral_ID WHERE (Category1 LIKE 'Grocery Store%' OR Category1 LIKE 'Specialty%' OR Category1 LIKE '%Delivery%' OR Category1 LIKE 'Greenmarkets%' OR Category1 LIKE 'Catering%' OR Category1 LIKE 'Wine, Beer%' )--0--Name-or-product--Name-or-product |

Go to


