<div>
<br />
<br />
use convert and convert styles <br />
convert(datatype,expressio<wbr />n,style)<br />
<br />
e.g.<br />
<br />

<pre><code id="code-20-36505500-1">select left(datename(mm,'2001'+right('00'+convert(varchar(2),period),2)+'01'),3) as Period
       ,convert(money,sales,1) as Sales
from (
select period,sum(sales) as sales
from salestable
group by period) as x
order by x.period</code></pre>
</div>




use convert and convert styles
convert(datatype,expression,style)

e.g.



select left(datename(mm,'2001'+right('00'+convert(varchar(2),period),2)+'01'),3) as Period
       ,convert(money,sales,1) as Sales
from (
select period,sum(sales) as sales
from salestable
group by period) as x
order by x.period

<div>
<div class="content wysiwyg-content">
I have only numeric values in a table. &nbsp;I want the output of a select statement to show text values rather than the numeric values. &nbsp;Modifying the table is not an option. &nbsp;I need to perform the substitution entirely within the select statement.<br />
<br />
Select Example:<br />
<br />
select period, sum(sales)<br />
from salestable<br />
<br />
Desired Output Example:<br />
<br />
Apr &nbsp;23,000<br />
May 50,000<br />
<br />
<br />
Table Data Example:<br />
<br />
Period Sales<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23,000<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50,000<br />
<br />
The actual data is much more complex, but a solution to the above should do it. &nbsp;Thanks in advance!<br />

</div>
</div>


I have only numeric values in a table.  I want the output of a select statement to show text values rather than the numeric values.  Modifying the table is not an option.  I need to perform the substitution entirely within the select statement.

Select Example:

select period, sum(sales)
from salestable

Desired Output Example:

Apr  23,000
May 50,000


Table Data Example:

Period Sales
4          23,000
5          50,000

The actual data is much more complex, but a solution to the above should do it.  Thanks in advance!


How to substitute text in the select statement output?

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.

Microsoft SQL Server 2005

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.