SQL Server Right（）函数用于从列上的某个点删除字符

I'm trying to remove text from my Description column after the "-" character. I know I would have to use the Right() function, but what would the syntax look like to loop through all the records and change all the records in the Description column?I'm trying to remove text from my Description c