T-SQL CASE in WHERE Clause and IN operator
<p>I trying to do this query where I have a where clause. The problem is that I need to use inside the <code>WHERE</code> condition the operator <code>IN</code>.</p>

<p>Anyone can help me?</p>

<p>Here is query. Thanks.</p>

<pre><code>DECLARE @title As Varchar(10)

SELECT * FROM EMPLOYEE
WHERE Title IN( CASE @title WHEN 'All' THEN  'FSOT','FSO','FISO','SFSO','PB','SPB' ELSE @title END)
</code></pre>