Opening a old thread for the benifit of someone landing here via a google search.
Translate now does exist in SQL Server 2017 🙂
Let's hope they didn't use the same technology as they did with FORMAT, which is 44 times slower than using native or brute force methods.
Haha!! That gives a interesting topic to explore. Will try a performance test soon 🙂