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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!