DECLARE @str VARCHAR(100)
SET @str = '1234567890'
SELECT REPLACE(@str,CHAR(179),'_')

12_4567890

DECLARE @str VARCHAR(100)
SET @str = '1234567890'
SELECT REPLACE( @str, CHAR(179) COLLATE SQL_Latin1_General_CP1_CI_AS, '_' ) AS Using_SQL_Latin1_General_CP1_CI_AS,
       REPLACE( @str, CHAR(179) COLLATE Latin1_General_CI_AS, '_' ) AS [Using_Latin1_General_CI_AS],
       CHAR(179) AS Replacing_Character

DECLARE @str VARCHAR(100)
SET @str = '1234567890'
SELECT REPLACE(@str collate Latin1_General_CI_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_CS_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_BIN2,CHAR(179),'_')