The problem is that when I execute the following script in SQL Query Analyser

set @NewLetterText = replace(@NewLetterText,'<SPAN id=§' + cast(@mLetterFieldID as varchar) + '§ hideFocus contentEditable=false unselectable=''ON'' ATOMICSELECTION=''true''>','')

It replace...

I am using this line of code in UDF , is there any alternative method to replace  sp_executesql , instead of cursors and temporary Tables

SET

@sql...