Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?
Have tried the following, which do not work:
column descr254_mixed format A30
set wrap off
select descr254_mixed from PS REQ_LINE
SELECT left(descr254_mixed, 20) from PS_REQ_LINE
Discuss This Question: