|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [BK].company_name) FROM [BK] Inner Join BK_A1 ON [BK].ID = BK_A1.Referral_ID WHERE (Category1 LIKE 'Clothing%' OR Category1 LIKE 'Gifts%' OR Category1 LIKE 'Office%' OR Category1 LIKE 'Pharma%' OR Category1 LIKE 'Florist%' OR Category1 LIKE 'Fabric%' )--0--Name-or-product--Name-or-product |

Go to


