parameterize a query containing an IN clause with a variable number of arguments
Try following query select * from [TestApp].[dbo].[Info] where '|pune |SDF |sfd |dgd |' like '%|' + adds + '|%' Result : f_name adds city state id zip nihar pune pune mah 1 23232 FSDF SDF SFS ...