Getting rid of curly brackets around loaded data

[TKendrick20]

I'm loading data from a SSMS database and I can't seem to get rid of these curly brackets around the data { }

Here is a sample

trim

([person_id])&'|'&(Date(current_date,'YYYYMMDD') as ProviderKey

Loads as

{XXXXX-XX-XXXX-XXX}|20130712

Why are they there and how do I get rid of them?

[Gysbert_Wassenaar · Accepted solution]

purgechar(person_id, '{}' ) is one option

textbetween(person_id,'{','}') is another

i.e. trim(purgechar([person_id],'{}'))&'|'&(Date(current_date,'YYYYMMDD') as ProviderKey

[TKendrick20]

Great, thank you. I was just confused because those brackets do not exist in the data that I am pulling from the SQL table.