Quick suggestion

😎

DECLARE @COMMENT NVARCHAR(200) = N'Work (210) 401-6838 for debtor(1) ''Guzman, Tarrasa'' status changed from Good to Bad';

SELECT REPLACE(@COMMENT,N'-',N'') AS CLEAN_COMMENT

Result

CLEAN_COMMENT

-----------------------------------------------------------------------------------

Work (210) 4016838 for debtor(1) 'Guzman, Tarrasa' status changed from Good to Bad