Ok that was embarrassingly easy.   I searched the web, but kept looking for special character identification.  Never thought to look for replace.  thanks

Ok so lets try this in steps.  in this example I need to source partitionkey 118 and then load the data back into the same table as partitionkey 123
So...

select p.Partitionkey

wow that is awesome. I forgot one item I need it only for partitionkey 7.  where would I put the where should I insert the where clause in your statement?

sorry my server was not available this morning so I could not test my code
this is the correct code

ok yes, the expected output does not have the local  currency identified.  the reason for this is, this information is going to a third party application that accounts use to create...

so awesome, it worked, and now I see  why I could not figure  it out.  A  DB Admin showed me select  statements  inside the From statement and it  just  did...

ok  thanks for  your answer.  And  your answer  is  my issue
if the entity ONLY has  USD, then the USD amount must  be  in BOTH columns
if the entity  has ...

I must say, for  some reason the insert  command  never  seems to work  for me.  hence  why  I  just  use  MS Access to load   data.   I  have  tried  numerous combinations...