--select dbo.f_dollar_shmolar(N'[$]1234567890$abcd$efgh[$]')
create function dbo.f_dollar_shmolar
(@input nvarchar(200))
returns nvarchar(200)
as
begin
declare @output nvarchar(200)
declare @i int, @length int,@symbol nchar(1)

select @output='',@length=LEN(@input),@i=1

DECLARE @dollar TABLE
(
  symbol nvarchar(1),
  ID int identity
)

while(@i<=@length)
begin
insert into @dollar
values(SUBSTRING(@input,@i,1))

set @i=@i+1
end
---------------------------------------------------------------------------------------------
select @i=1
 while(@i<=@length)
 begin
		select @symbol=symbol from @dollar
		where ID=@i
		
		if @symbol='['
		begin
				while (@symbol<>']')
				begin
				set @output=@output+@symbol
				set @i=@i+1
				if @i>@length return @output
				
				select @symbol=symbol from @dollar
				where ID=@i
				end 
		end
		if @symbol='$' set @output=@output+'^'
		if @symbol<>'$' set @output=@output+@symbol
		set @i=@i+1
 end
---------------------------------------------------------------------------------------------
return @output
end