<div>
I would just update your table:<br />
<br />
update table set &lt;column&gt; = replace(&lt;Column&gt;, '-', '')<br />
<br />
if you just wanted to do it on the select<br />
<br />
select replace(&lt;Column&gt;, '-', ''), * <br />
from table
</div>


I would just update your table:

update table set <column> = replace(<Column>, '-', '')

if you just wanted to do it on the select

select replace(<Column>, '-', ''), *
from table

<div>
Great idea but since I have 3 different situations being the - or -O or just O how do I get all 3 in that statement
</div>


Great idea but since I have 3 different situations being the - or -O or just O how do I get all 3 in that statement

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for debschultz's comment <a href="https://www.experts-exchange.com/questions/28173924/SQL-2008-Reporting-Services.html?anchorAnswerId=39294358#a39294358" rel="ugc">#a39294358</a><br />
<br />
for the following reason:<br />
<br />
Although it may not be as tough of a question the response was amazing and right on.
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for debschultz's comment #a39294358 [https://www.experts-exchange.com/questions/28173924/SQL-2008-Reporting-Services.html?anchorAnswerId=39294358#a39294358]

for the following reason:

Although it may not be as tough of a question the response was amazing and right on.

<div>
Replacing the - will allow for comparison and allow it to be grouped. &nbsp;Please note you selected you own question as the solution, did you mean to accept mine?
</div>


Replacing the - will allow for comparison and allow it to be grouped.  Please note you selected you own question as the solution, did you mean to accept mine?

<div>
<div class="content wysiwyg-content">
Need help in how to effectively write this custom code for my report. &nbsp;I have a field that houses truck numbers and for the report need to correct errors. &nbsp;Example: &nbsp;Truck numbers W01 can be entered as W-01, W-O1, WO1 - these go up to 09. &nbsp;Also truck numbers ZUC01 are entered as ZUC-01, ZUC-O1, ZUCO1 and go up to 09. &nbsp;Suggestions would be grealy appreciated on the most effective way to code this.
</div>
</div>


Need help in how to effectively write this custom code for my report.  I have a field that houses truck numbers and for the report need to correct errors.  Example:  Truck numbers W01 can be entered as W-01, W-O1, WO1 - these go up to 09.  Also truck numbers ZUC01 are entered as ZUC-01, ZUC-O1, ZUCO1 and go up to 09.  Suggestions would be grealy appreciated on the most effective way to code this.

SQL 2008 Reporting Services

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.