I'm in a bit of a pickle: I've been asked to take in comments starting with a specific string from a database, and separate the result into separate columns.
For example -- if a returned value is this:
COLUMN_ONE
--------------------
'D7ERROR username'
The return needs to be:
COL_ONE COL_TWO
--------------------
D7ERROR username
Is it even possible to define columns once the result set has been structured just for the sake of splitting a string into two?
See Question&Answers more detail:os