|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [GU].company_name) FROM [GU] Inner Join GU_A1 ON [GU].ID = GU_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


