Thanks guys, I managed to find a workaround.

It is difficult to understand though that MS have provided the TEXT datatype but no clear indication of how to use it as...