>>>>the SQL server (TSQL) equivalent for
>>>>

>>>>Strtran(Strtran(Strtran(m.tcChain, [&], '&#38;'), [<], '&#60;'), [>], '&#62;')
>>>>

>>>
>>>Exactly! :) Now if I just knew what it was.... :)
>>
>>http://technet.microsoft.com/en-us/library/ms186862.aspx
>
>Both columns are TEXT :(

Cast them ?

select cast(Replace(Replace(Replace(cast( col1 as nvarchar(max)), '&', '&#38;'), '<', '&#60;'), '>', '&#62;') as Text)
	from @TmpPrefix