SQLServer 2005 - Update field after stiping brackets from data

[ReportDr00]

Hello
I have a field that contains data in below format
{FFFFFFFF-0000-0000-0000-000000000463}
{FFFFFFFF-0000-0000-0000-000000000463}
{FFFFFFFF-0000-0000-0000-000000000463}
{FFFFFFFF-0000-0000-0000-000000001576}
{FFFFFFFF-0000-0000-0000-000000001576}
{FFFFFFFF-0000-0000-0000-000000000606}
{FFFFFFFF-0000-0000-0000-000000000850}
{FFFFFFFF-0000-0000-0000-000000000850}
{FFFFFFFF-0000-0000-0000-000000001576}
and i would like to strip { and } from begining and end of the string and store the data.
How can i do this in a query?

Thanks

 

[markros]

update myTable set NewData = substring(CurrentData,2,len(CurrentData)-1)

 

[ReportDr00]

It worked.

Thanks Mark

 

[markros]

You're welcome.