I have a SQL column that needs to be split. Some of the column (Column name is City) values are : Chicago (0078), Seattle (02136), Omaha (008721) and they need to be split as 

```
City: Chicago, Seattle, Omaha. 
MU: 0078, 02136, 008721

```

I am not sure if SQL has a built-in function for this purpose or should I use variables?