Using 'IN' clause for strings in Sql
<p>Hi I have table which have 2 column. <code>Name varchar(50)</code> and <code>RoleType Varchar(500)</code>.</p>

<p>I have data as below img in table.
<a href="https://i.stack.imgur.com/YUXXO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YUXXO.png" alt="enter image description here"></a></p>

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

<p>I try with below query but it is not working.</p>

<p><code>SELECT * FROM Userinfo where Roletype in ('2', '4')</code></p>