Thanks for all the replies.

I too came across recommendation to use 'nvarchar' instead of 'ntext'.

Not sure how this would have worked with SQL server 2012! I will have to ask...