hi,
I need help with formatting a column <b>item description </b> varchar2(240) <b>APPS.PO_LINES</b> table where it contains data like the following:
1. OSP FIBER ACCESSORY-CLOSURE-FIBER-48 F-CAPITAL-NONE-NONE
2. OSP PVC-PVC PIPE-NONE-50 M.M-CAPITAL-NONE-NONE
3. OSP PVC ACCESSORY-BEND PIPE-BEND PIPE 90 DGREE-100 M.M-CAPITAL-NONE-NONE
4. Work manship
I need to format the column in a select statement in such a way that it excludes the the last three<b> -CAPITAL-NONE-NONE</b> when the column contains them.
Any idea?
Formattin item description column
Who is online
Users browsing this forum: No registered users and 5 guests