• This is what I have been looking for and forgive me if this is a simple question (I am trying to learn some of these concepts, like in-line table-valued functions), but how do you easily apply this to an entire table? How do you use this, even? It returns a table (not permanent), so I selected the result set into a new table, but I don't know if that defeats the point of using the TVF in the first place.

    This:

    select * into dbo.testtable from

    (SELECT t1.id as id, t1.title as title, clean.cleaned as cleaned from t1

    cross apply dbo.if_cleanwithreplace(t1.title) clean) a

    fixes one column