|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [NG].company_name) FROM [NG] Inner Join NG_A1 ON [NG].ID = NG_A1.Referral_ID WHERE (Category1 LIKE '%Cleaner%' OR Category1 LIKE 'Cleaning%' OR Category1 LIKE 'Pest%' OR Category1 LIKE 'Personal%' OR Category1 LIKE 'Burial%' OR Category1 LIKE 'Bank%' OR Category1 LIKE 'Real%' OR Category1 LIKE 'Telecom%' OR Category1 LIKE 'Utilit%' OR Category1 LIKE 'Carbon%' )--0--Name-or-product--Name-or-product |


Go to


