<div>
Assuming your column name is myCol, this could work.<br />
<br />
SELECT LEFT(myCol,6)+REVERSE(SUBS<wbr />TRING(myCo<wbr />l,7,2))+RI<wbr />GHT(myCol,<wbr />4)
</div>


Assuming your column name is myCol, this could work.

SELECT LEFT(myCol,6)+REVERSE(SUBSTRING(myCol,7,2))+RIGHT(myCol,4)

<div>
<div class="content wysiwyg-content">
I have a field in a table that contains data that I need to manipulate for sorting. &nbsp;And I need to do this just as an output &nbsp;using a select query (I don't want to change it in the table). &nbsp;I need to select 3 fields; tempid, type, location. &nbsp; &nbsp;The &quot;location&quot; field contains the data to be manipulated. &nbsp; Here's a few examples:<br />
<br />
SB-01-F3-015 - &nbsp;I need this to OUTPUT as SB-01-3F-015<br />
SB-01-B4-010 - &nbsp;I need this to OUTPUT as SB-01-4B-010<br />
SB-01-D2-008 - &nbsp;I need this to OUTPUT as SB-01-2D-008<br />
<br />
I assume you use some kind of replace command... &nbsp;The command will always be transposing the 4th and 5th character of the location field.
</div>
</div>


I have a field in a table that contains data that I need to manipulate for sorting.  And I need to do this just as an output  using a select query (I don't want to change it in the table).  I need to select 3 fields; tempid, type, location.    The "location" field contains the data to be manipulated.   Here's a few examples:

SB-01-F3-015 -  I need this to OUTPUT as SB-01-3F-015
SB-01-B4-010 -  I need this to OUTPUT as SB-01-4B-010
SB-01-D2-008 -  I need this to OUTPUT as SB-01-2D-008

I assume you use some kind of replace command...  The command will always be transposing the 4th and 5th character of the location field.

MS SQL 2005 substring - replace question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.