Another way to do it using STUFF.
declare @testid varchar(50)=
'{784A4579-8689-438E-ADAA-9DCBC8A88AE7}'
select STUFF(stuff(@testid,len(@testid),len(@testid),''),1,1,'')
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: