PS. 2008 R2.

Ive only really been using MDX for about 3 days (I did some stuff a few years ago), so any advice would be helpful!

im saying that the other system that we interact with uses this as part of the key

Hi,

Firstly, thanks for the response;

Yes, we potentially need to keep the control chars in there. The data comes from another system, that also spits data out to other places...