<div>
None that I'm aware of, other than CASTing the value with the appropriate number of decimal places. <br />
Give us a data mockup of what you're trying to pull off here.
</div>


None that I'm aware of, other than CASTing the value with the appropriate number of decimal places.
Give us a data mockup of what you're trying to pull off here.

<div>
<div class="content wysiwyg-content">
I know SQL Server 2008 doesn't have the &quot;Format&quot; command. Is there a way of truncating zeroes after a decimal point?<br />
<br />
Thanks!
</div>
</div>


I know SQL Server 2008 doesn't have the "Format" command. Is there a way of truncating zeroes after a decimal point?

Thanks!

Formatting a decimal value in SQL SERVER 2008

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.