sql remove characters from string whit regex in query code example

Example: reutrn string after character sql

select right(col, charindex('-', reverse(col)) - 1)