TRANSLATE() is a string function introduced in SQL Server 2017. Using TRANSLATE is simple and straightforward compared to REPLACE function.