Hi Dave 23, thanks for replying.

When I run it I just get the whole [Business Unit] string value.

I have also tried:

SUBSTRING([Business Unit],4,LEN([Business Unit]) - 3)

and that returns the whole [Business Unit] string as well.

The datatype is Unicode (DT_WSTR).

:crazy: