<div>
you're padding with a null string ''<br />
<br />
either don't use the 3rd parameter of lpad, &nbsp;or provide a space character &nbsp; ' ' &nbsp;or chr(32) &nbsp;as the 3rd parameter
</div>


<div>
If you have a value of '123 Main Street' in addr1 that is data type char(30), selecting it would produce a result of 123 Main Street followed by 15 spaces. Then adding the substr and lpad functions would produce a result of 123 Main Street preceded by 10 spaces and followed by 15 spaces. Is that what you want? Also, taking the substr of a fixed char field with a length of 30 from 1 to 40 simply produces the entire field and is not necessary. If you're trying to make the addr1 appear to be right justified to 40 characters, you should trim it first before applying the lpad function.
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to add the address; which is a char 30, to my oracle sql delimited query.<br />
The length is supposed to be set to 40. <br />
<br />
I'm using the following code, but its only returning a 0.<br />
||lpad(substr(emp.addr1,1,<wbr />40),40,'')<wbr /><br />
<br />
Can someone help me correct this.<br />
<br />
Thanks
</div>
</div>


I'm trying to add the address; which is a char 30, to my oracle sql delimited query.
The length is supposed to be set to 40. 

I'm using the following code, but its only returning a 0.
||lpad(substr(emp.addr1,1,40),40,'')

Can someone help me correct this.

Thanks

Oracle SQL Char delimited error

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.