Advanced Search Using Select query having Where Clause as Where ColoumnName in..

I resolved my problem by adding this stored checked valued in string country, industry....

select CompanyName, All_Countries, All_Industries, Employees, Revenue from testCompany Where All_Countries in (" + country + ") and All_Industries in (" + industry + ") and Employees_Range in (" + employees + ") and Revenue_Range in (" + revenue + ")