<div>
Try the Round function in SQL<br />
<br />
<a href="http://www.w3schools.com/sql/sql_func_round.asp" rel="ugc">http://www.w3schools.com/sql/sql_func_round.asp</a>
</div>


<div>
Hi Thanks but it does not omit the zeros. I would try the Format function -Do you know how I can specify the format string?
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have an unbound datagrid view, I need to format data from 0.07620000000000000 to 6 digits after decimal. Can that be done by code? my SQL is :<br />
&quot;SELECT TOLP, TOLM,0 AS SEQ, KKD*25.4/1000 AS REQ ,TOLP*25.4/1000 AS PTOL, &quot;_ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp; &quot;&nbsp; ,KNO, 0 AS MEASURED FROM BPCSELTF.KDHE&quot;
</div>
</div>


Hi Experts,
I have an unbound datagrid view, I need to format data from 0.07620000000000000 to 6 digits after decimal. Can that be done by code? my SQL is :
"SELECT TOLP, TOLM,0 AS SEQ, KKD*25.4/1000 AS REQ ,TOLP*25.4/1000 AS PTOL, "_            & "  ,KNO, 0 AS MEASURED FROM BPCSELTF.KDHE"

Try the Round function in SQL

http://www.w3schools.com/sql/sql_func_round.asp

Hi Thanks but it does not omit the zeros. I would try the Format function -Do you know how I can specify the format string?

Format Unbound DataGridView

Hi Experts,
I have an unbound datagrid view, I need to format data from 0.07620000000000000 to 6 digits after decimal. Can that be done by code? my SQL is :
&amp;quot;SELECT TOLP, TOLM,0 AS SEQ, KKD*25.4/1000 AS REQ ,TOLP*25.4/1000 AS PTOL, &amp;quot;_            &amp;amp; &amp;quot;  ,KNO, 0 AS MEASURED FROM BPCSELTF.KDHE&amp;quot;

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,