If the length of the string might vary - but there will always be brackets - this will work:

declare @string varchar(max)

set @string = '{String you want to remove from the brackets}'

select SUBSTRING(@string, CHARINDEX('{',@string)+1,Charindex('}',@string)-2)