Hi I have table which have 2 column. `Name varchar(50)` and `RoleType Varchar(500)`.

I have data as below img in table.
[![enter image description here](https://i.stack.imgur.com/YUXXO.png)](https://i.stack.imgur.com/YUXXO.png)

Now I am passing `roletype` 2 and 4 as parameter and want to get all data which have `roletype` either 2 or 4 in `Roletype` column. For example, result for 2 and 4 `roletype` are Test a, Test d, Test c and Test e.

I try with below query but it is not working.

`SELECT * FROM Userinfo where Roletype in ('2', '4')`