<div>
002 is char?<br />
<br />

<pre><code id="code-178114">case when code = '1M' then 'FM' when inv_cd = '002' then 'SOLDMTG' end as PRODID
</code></pre>
</div>


002 is char?



case when code = '1M' then 'FM' when inv_cd = '002' then 'SOLDMTG' end as PRODID


<div>
I tried with commas but still get all FM
</div>


<div>
i didn't know that, thank you ...it worked
</div>


i didn't know that, thank you ...it worked

<div>
<div class="content wysiwyg-content">
I have 2 diff fields, code which is always &quot;1M&quot; and inv_cd which is 001 and 002...in my following case stmt i would to say that if code is 1M then 'FM' but if inv_cd has 002 then SOLDMTG, in following stmt i am getting all FM even in some inv_cd there is 002, is this possible?<br />
<br />
<br />
case when code = '1M' then 'FM' when inv_cd = 002 then 'SOLDMTG' end as PRODID
</div>
</div>


I have 2 diff fields, code which is always "1M" and inv_cd which is 001 and 002...in my following case stmt i would to say that if code is 1M then 'FM' but if inv_cd has 002 then SOLDMTG, in following stmt i am getting all FM even in some inv_cd there is 002, is this possible?


case when code = '1M' then 'FM' when inv_cd = 002 then 'SOLDMTG' end as PRODID

Case stmt

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.