You shoudl be able to cast nText as NVARCHAR(MAX) and then use normal SQL syntax to search and replace for the string values you want using the SQL REPLACE function ... I think ...
Loading User Information from Channel 9
Something went wrong getting user information from Channel 9
Loading User Information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
You shoudl be able to cast nText as NVARCHAR(MAX) and then use normal SQL syntax to search and replace for the string values you want using the SQL REPLACE function ... I think ...