<div>
Look for CONVERT help. There is third parameter whch specifies format.
</div>


Look for CONVERT help. There is third parameter whch specifies format.

<div>
This worked, but insn't there a way to format those numbers?
</div>


This worked, but insn't there a way to format those numbers?

<div>
No other way than specifiing number of decimal places.<br />
Formating is normaly presentation layer function so SQL has no need to do this.
</div>


No other way than specifiing number of decimal places.
Formating is normaly presentation layer function so SQL has no need to do this.

<div>
<div class="content wysiwyg-content">
Experts,<br />
I'm trying to select a combination of text and numbers as below:<br />
SELECT &nbsp;N' &nbsp; &nbsp; &nbsp;P_Index: &nbsp; ' + convert(nvarchar,PriceInde<wbr />x) + ' (' + convert(nvarchar,dbo.Clien<wbr />t_Online_I<wbr />ndices.Cha<wbr />nge) + ') &nbsp; ' &nbsp;AS Total<br />
<br />
The problem is that i get a wrongly formatted output: <br />
P_Index: &nbsp;1.45448e+007 <br />
<br />
I need the numbers to look properly!<br />

</div>
</div>


Experts,
I'm trying to select a combination of text and numbers as below:
SELECT  N'      P_Index:   ' + convert(nvarchar,PriceIndex) + ' (' + convert(nvarchar,dbo.Client_Online_Indices.Change) + ')   '  AS Total

The problem is that i get a wrongly formatted output: 
P_Index:  1.45448e+007 

I need the numbers to look properly!


Numeric Output Format

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.