|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [HP].company_name) FROM [HP] Inner Join HP_A1 ON [HP].ID = HP_A1.Referral_ID WHERE (Category1 LIKE 'Building%' OR Category1 LIKE 'Alternative%' OR Category1 LIKE 'Garden%' OR Category1 LIKE 'Arch%' OR Category1 LIKE 'Salvage%' )--0--Name-or-product--Name-or-product |


Go to


