SQL Server- CASE WHEN THEN in list- multiple values
<p>I know that SQL CASE will not accept <code>in list</code> for the <code>then</code> part of the <code>CASE</code> statement. </p>

<p>What I am ideally looking for is such a case:</p>

<pre><code>CASE WHEN 'A' Then in list ['B' , 'C'] ELSE 'A' END
</code></pre>

<p>or </p>

<pre><code>CASE WHEN 'A' Then 'B' or 'C' ELSE 'A' END
</code></pre>

<p>I am using this CASE Statement as a part of Designing a SQL view. </p>

<p>Just to let you know, I have already checked <a href="https://stackoverflow.com/questions/6945660/multiple-values-in-sql-cases-then-statment">Multiple values in SQL CASE&#39;s THEN Statement</a> and the answer there didn't work for me.</p>

<p>EDIT, PROBLEM Description and Dummy Data:</p>

<p>My main table is  <code>dbo.main</code> 
In this table I have data in form</p>

<pre><code>Year    CTG
2015    A
2015     B
2015    C
2015    D
</code></pre>

<p>In my design view I worte this: </p>

<pre><code>SELECT DISTINCT YEAR, 'GENRL' AS SETID, '000001' AS LABOR_AGREEMENT, CTG
FROM            dbo.main
</code></pre>

<p>Now my ultimate goal is to have below table:</p>

<pre><code>Year    CTG
2015    B/C
2015     B
2015    C
2015    D
</code></pre>

<p>The <code>CTG</code> value is a key to initiate another table in another page, and I want that table to show all the values for <strong>CTG: B</strong> and <strong>CTG:C</strong></p>