name
12$130 $130
13123$130 $130
124124124 $130 $130

name
12
13123
124124124

DECLARE @a varchar(255) = '124124124 $130 $130'

SELECT CASE WHEN CHARINDEX('$',@a) <> 0 THEN SUBSTRING(@a,0,CHARINDEX('$',@a)) ELSE @a END

SELECT [old] = name, [new] = CASE WHEN CHARINDEX('$',name) <> 0 THEN SUBSTRING(name,0,CHARINDEX('$',name)) ELSE name END
FROM [user].[dbo].[Street]

UPDATE [user].[dbo].[Street]
SET name = SUBSTRING(name,0,CHARINDEX('$',name)) 
FROM [user].[dbo].[Street]
WHERE 
	CHARINDEX('$',name) <> 0