Skip to content
Home » translate vs replace in sql

translate vs replace in sql

SQL TRANSLATE()

 The SQL TRANSLATE() is a string function that is used to replaces a sequence of characters in a string with another sequence of characters.

The function replaces a single character at a time.  Until SQL Server 2016, we used use REPLACE() function to replace each character.

Loading