sql server 2017 - SQL splitting a string

Question

From the dept column, I want to create a new column that just returns what is on the right side of the hyphen. It should look like the NewDept column. Thank you

question from:https://stackoverflow.com/questions/65598385/sql-splitting-a-string

Answer 1

Waitting for answers