I am working with a table that contains two versions of stored information. To simplify it, one column contains the old description of a file run while another column contains the updated standard for displaying ran files. It gets more complicated in that the older column can have multiple standards within itself. The table:

```
Old Column              New Column
Desc: LGX/101/rpt          null
  null                     Home
Print: LGX/234/rpt         null
  null                     Print
  null                     Page

```

I need to combine the two columns into one, but I also need to delete the "Print: " and "Desc: " string from the beginning of the old column values. Any suggestions? Let me know if/when I'm forgetting something you need to know!

(I am writing in Cache SQL, but I'd just like a general approach to my problem, I can figure out the specifics past that.)

EDIT: the condition is that if substr(oldcol,1,5) = 'desc: ' then substr(oldcol,6)
 else if substr(oldcol,1,6) = 'print: ' then substr(oldcol,7) etc. So as to take out the "desc: " and the "print: " to sanitize the data somewhat.

EDIT2: I want to make the table look like this:

```
    Col
  LGX/101/rpt
    Home
  LGX/234/rpt
    Print
    Page

```