Given a string which looks like this:
'Workstation - Base Unit - Hard Drive'
How can I get the data into the format shown in the screenshot? In other words, split the text (which is delimited by ' - ') from the full string so that it is in separate columns?
I'm sure I could figure this out, but I've just spent several hours on another thorny SQL problem and need to speed up a bit!