仅在使用CASE WHEN时SQL查询返回错误

I have the sql code below and the case when statement is always returning the 'Error converting data type varchar to numeric'. But if I comment it out then the statement runs successfully even though the same code is used in the first column.I have the sql code below and the case when sta