The code I provided did stop with a numeric overflow. What's different about her code?
>>Thanks, Sergey. In other words, I can not use replace command in the UDF, which is called by replace. How about insert from? I'll try it...
>>
>>I can not use your suggestion, since it has to be just one long replace command...
>>
>>I'm in the middle of trying public array idea and I also try insert idea...
>
>Looks like INSERT in the function doesn't cause the problem, at least in the test code.
>
>>I doubt, what the fact, that you can not use REPLACE command in UDF while doing REPLACE command is either mentioned anywhere...!
>
>
>You can use REPLACE command in UDF while doing REPLACE command if master REPLACE doesn't cause numeric overflow or you don't want to catch it. :)