<div>
select <br />
left(replace(replace(Locat<wbr />ion,'DN','<wbr />NA'),'DW',<wbr />'WA'),4) AS Location,Count <br />
from &lt;TableName&gt;
</div>


<div>
<div class="content wysiwyg-content">
I would like to write an IIF statement that converts the example query:<br />
<br />
Location &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Count<br />
DN01 00 01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
DN01 00 02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5<br />
DN02 00 01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
DW01 00 01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
DW01 00 02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
DW02 00 02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
DW03 00 01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
<br />
To convert the previous example to this:<br />
<br />
Location &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Count<br />
NA10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
NA10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
WA01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
WA01 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
WA02 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
<br />
Basically, Everytime it shows a &nbsp;DN change to NA, Everytime it shows a DW change to WA. &nbsp;Then also I only want to see the left 4 places after the text replacements take place. &nbsp;I only have read access to the host data system, so I can not change the locations in the system.
</div>
</div>


I would like to write an IIF statement that converts the example query:

Location	Count
DN01 00 01	4
DN01 00 02	5
DN02 00 01	4
DW01 00 01	3
DW01 00 02	1
DW02 00 02	4
DW03 00 01	1

To convert the previous example to this:

Location	Count
NA10 	4
NA10 	2
WA01	3
WA01	1
WA02	4

Basically, Everytime it shows a  DN change to NA, Everytime it shows a DW change to WA.  Then also I only want to see the left 4 places after the text replacements take place.  I only have read access to the host data system, so I can not change the locations in the system.

select 
left(replace(replace(Location,&#39;DN&#39;,&#39;NA&#39;),&#39;DW&#39;,&#39;WA&#39;),4) AS Location,Count 
from &lt;TableName&gt;

How to properly use an IIF statement with multiple criterion?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.