• Thanks for the article, Wayne.

    Very informative and well written!

    Along the same line, I recently compared the format function with some other T-SQL and CLR methods here.

    Turns out that FORMAT is very powerful, but not fast.

    -- Gianluca Sartori