Similar to some of the posts above - here's my version using a function. It performs well.

Here's the function:

CREATE FUNCTION dbo.fn_title_case

(

@string ...

What a badly-worded question - it was not clear whether the question was about the contents of @tab or TestTable :crazy: