2 Replies Latest reply: Jul 12, 2013 10:50 AM by Tim Kendrick RSS

    Getting rid of curly brackets around loaded data

    Tim Kendrick

      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?