The REPLACE solution can be made to run an order of magnitude faster if we use an in-line table-valued function instead of an evil scalar function:
I am not getting the exact meaning of this statement.
what do you mean by order of magnitude ?
you mean to say even though if we use REPLACE function in an in-line table valued function the performance will be good. Am i correct?
karthik