In most of my SSRS reports I use IN or = for Parameters, but sometimes you may need to use Like in the where clause. There are a number of ways you can do this, but I am only showing the method I use.
Select * from Test
Where UserName Like '%' + @ParameterName + '%'
