Dennes Torres shows off four T-SQL functions releasing in SQL Server 2017:
Translate
Translate does the work of several replace functions, simplifying some queries.
The function is called ‘Translate’ because its main objective: transform one kind of information in another by doing a bunch of replaces.
For example: GeoJson and WKT are two different formats for coordinates. In GeoJson a coordinate is represented using the format ‘[137.4, 72.3]’ while in WKT a point is represented using the format ‘(137.4 72.3)’.
We would need several ‘Replace’s to transform GeoJson format in WKT format and the reverse. The ‘Translate’ function can do this easily.
I knew the first three, but Translate sneaked right past me.