I convert my old stored procedure (SQL Server 2016) to a natively compiled procedure and in one place I receive:
SELECT @name = REPLACE(@inname, ':' + @new + ':', ':' + @old + ':')
Msg 10794, Level 16, State 93, Procedure usp_2, Line 101 [Batch Start Line 108]
The function 'replace' is not supported with natively compiled modules.
How to replace the function REPLACE()
?