与数据。表，返回某些字符到一个新的列中

I have a feeling this might be a simple question, but I've searched through SO for a bit now and found many interesting related Q/A, I'm still stumped.I have a feeling this might be a simple questio