<div>
I managed to solve the problem by using Trim<br />
<br />
a.version &nbsp; &nbsp; &nbsp;= Trim(TO_CHAR( a.version + 1, '00000'))<br />
<br />
Is there any explanation for this, why is a space being inserted?<br />
<br />
Thanks.
</div>


I managed to solve the problem by using Trim

a.version      = Trim(TO_CHAR( a.version + 1, '00000'))

Is there any explanation for this, why is a space being inserted?

Thanks.

<div>
- check the actual value of a.version what is its exact length or data type?
</div>


- check the actual value of a.version what is its exact length or data type?

<div>
So how would you go around it? Is it necessary to use the trim or maybe some other code could be used?<br />
<br />
thanks.
</div>


So how would you go around it? Is it necessary to use the trim or maybe some other code could be used?

thanks.

<div>
the code you used just about sums it up.
</div>


<div>
<div class="content wysiwyg-content">
Hi I am trying to update a field which has &nbsp;a fomat of '00000'. <br />
<br />
When I update using this code:<br />
<br />
a.version &nbsp; &nbsp; &nbsp;= TO_CHAR( a.version + 1, '00000')<br />
<br />
I am getting for instance ' 00001'. Please note the space before the zeros.<br />
<br />
Any help please? <br />
Thanks.
</div>
</div>


Hi I am trying to update a field which has  a fomat of '00000'. 

When I update using this code:

a.version      = TO_CHAR( a.version + 1, '00000')

I am getting for instance ' 00001'. Please note the space before the zeros.

Any help please? 
Thanks.

Space inserted when Incrementing a 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.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.