Splitting a column on underscores


What SQL syntax would split this column into three new columns (split would be on the underscore)?

enter image description here

There are other columns in the table, but I would like to split these into three (underscore based).