<div>
Would this work?<br />
SELECT ROUND (MyNumber, &nbsp;4)<br />

</div>


Would this work?
SELECT ROUND (MyNumber,  4)


<div>
Note: TRUNC will truncate decimal places (i.e. lose digits),<br />
whereas ROUND will round down or up to the nearest value, to the specified number of decimal places.<br />

</div>


Note: TRUNC will truncate decimal places (i.e. lose digits),
whereas ROUND will round down or up to the nearest value, to the specified number of decimal places.


<div>
 I think so.... good thinking, very logical. <br />
I will test some more but looks to give the right output. <br />

</div>


I think so.... good thinking, very logical.
I will test some more but looks to give the right output.


<div>
<div class="content wysiwyg-content">
In a large select stmt, on of the columns I am reading from contains a number (double). This column may contain a whole number, or may contain a decimal. Sometimes the decimal is very long. <br />
<br />
I am looking to round the decimial to 4, but only when required. If the number is whole or less than 4 decimals I prefer it stay that way. <br />
<br />
How would I do this? <br />
I am quering against a DB2 database
</div>
</div>


In a large select stmt, on of the columns I am reading from contains a number (double). This column may contain a whole number, or may contain a decimal. Sometimes the decimal is very long. 

I am looking to round the decimial to 4, but only when required. If the number is whole or less than 4 decimals I prefer it stay that way. 

How would I do this? 
I am quering against a DB2 database

SQL round decimal

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

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.