I have a string like this `"Planck, Albert, Bohr"`

I want the output as `"Bohr Albert Planck"` 

I want this done using SQL server. I saw many string split functions all return the data as a table and in the forward order. These don't server my purpose.

Any pointers will be helpful.