SSMS-删除下划线和连字符

drop table if exists #test;
go
--------
select
    'Student_is_behind_–_concerned_about_his_or_her_ability_to_catch_ nvarchar(255), ' as [test_col_1]
into
    #test;
go
----------------
select
    [test_col_1]
    ,replace([test_col_1],'_-_','_') as [col_1_adj]
from
    #test;
go

Student_is_behind_–_concerned_about_his_or_her_ability_to_catch_ nvarchar(255), 

_-_ 具有 _ .

我做错什么了?

出于某种原因,当我不把值放在列中时,它就起作用了,但我不知道为什么。