<div>
which version of toad u r using?
</div>


<div>
At the suggestion of a colleague I tried the substr command:<br />
<br />
select a.wonum, a.followupfromwonum, a.description, substr(b.ldtext,1,30),c.na<wbr />me, d.regularhrs, d.othrs<br />
<br />
Now for the new problem  ORA-00932: inconsistent datatypes; expected NUMBER got LONG is an error that I get.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
The following select statement is part of a database query:<br />
<br />
select a.wonum, a.followupfromwonum, a.description, b.ldtext,c.name, d.regularhrs, d.othrs<br />
<br />
When the query is executed there is information &quot;visible&quot; in the output. &nbsp;Yet when I export the output to text file for further manipulation the ldtext output does not carry over. &nbsp;The data type is &quot;memo.&quot; &nbsp;I've tried cast, convert, etc. with no effect. &nbsp;Any suggestions?
</div>
</div>


The following select statement is part of a database query:

select a.wonum, a.followupfromwonum, a.description, b.ldtext,c.name, d.regularhrs, d.othrs

When the query is executed there is information "visible" in the output.  Yet when I export the output to text file for further manipulation the ldtext output does not carry over.  The data type is "memo."  I've tried cast, convert, etc. with no effect.  Any suggestions?

converting memo/long datatype to something I can export

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.