I cannot seem to put this together properly.
I have a column path that has string data I want parsed out.
select path from paths
path
-------------------------------------
Canon:Canon Toner
Data Products:Data Products Toner
Epson:Epson Inkjet Cartridges
Tektronix by Xerox:Tektronix Ink Sticks
what i would like is something like this
Toner
Products Toner
Inkjet Cartridges
Ink Sticks
That is.... after the colon, find the first space and give the rest of the
string.
TIA for any ideas
Chad