<div>
@schwertner: that method will not work if the first 0 is in a significant position. For example, use 103900.
</div>


@schwertner: that method will not work if the first 0 is in a significant position. For example, use 103900.

<div>
Thats right! Thanks for the remark.<br />
But the method can be fixed, because INSTR fuction can also<br />
work from right to left.
</div>


Thats right! Thanks for the remark.
But the method can be fixed, because INSTR fuction can also
work from right to left.

<div>
The best way to solve the problem is to write a function.<br />
Functions could be called from SQL statements.
</div>


The best way to solve the problem is to write a function.
Functions could be called from SQL statements.

<div>
Thanks for the help. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I like to have a sql to round a 6 digit number like the following. &nbsp;The length will alway to 6 digit and I like replace the last none 0 digit with 0. &nbsp;For example:<br />
<br />
122000 to become 120000<br />
120000 to become 100000<br />
133400 to become 133000<br />
133900 to become 133000<br />
<br />

</div>
</div>


I like to have a sql to round a 6 digit number like the following.  The length will alway to 6 digit and I like replace the last none 0 digit with 0.  For example:

122000 to become 120000
120000 to become 100000
133400 to become 133000
133900 to become 133000



Round a 6 digit number

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.