SQL*Plus..Tricky question!
Date: 1995/08/15
Message-ID: <40qdci$ln5_at_cville-srv.wam.umd.edu>#1/1
okay, here's a tricky question for all you Sql*Plus people:
I have a 60 character field (char) that will look like this:
What I'm trying to do is to only take the charcters up to divison or up
to office whatever comes first, to get the folllowing output:
CONTRACTING DIVISION OFFICE OF THE CHEIEF
FA DIVISION OFFICE OF THE CHIEF
RESOURCE MANAGEMENET DIVISION OFFICE OF THE CHIEF
INFROMATION MANAGEMENT OFFICE
PUBLIC AFFAIRS OFFICE OF THE CHIEF
CONTRACTING DIVISION
FA DIVISION
RESOURCE MANAGEMENT DIVISION
INFROMATION MANAGEMENT OFFICE
PUBLIC AFFAIRS OFFICE
Can this be done with substr or what?
(Please excuse the spelling errors, I'm using a new editor and I don't quite have the hang of it yet)
-T.J. Received on Tue Aug 15 1995 - 00:00:00 CEST