SQL Server TRANSLATE() Function

The SQL Server (Transact-SQL) TRANSLATE() function returns a given string after replacing a sequence of characters in the string with another set of characters.

The function returns an error if string_to_replace and replacement_string expressions have different lengths. It returns NULL if any of the arguments are NULL.

Syntax

TRANSLATE(string1, string_to_replace, replacement_string)

Parameters

`string1`	`Required.` Specify the string to replace a sequence of characters with another set of characters.
`string_to_replace`	`Required.` Specify the string that will be searched for in string1.
`replacement_string`	`Required.` Specify the replacement string. All characters in the string_to_replace will be replaced with the corresponding character in the replacement_string.

Return Value

Returns the given string after replacing a sequence of characters in the string with another set of characters.

Example:

The example below shows the usage of TRANSLATE() function.

SELECT TRANSLATE('12345', '143', 'abc');
Result: 'a2cb5'

SELECT TRANSLATE('12345', '123', 'ABC');
Result: 'ABC45'

SELECT TRANSLATE('2*[3+4]/{7-2}', '[]{}', '()()');
Result: '2*(3+4)/(7-2)'

SELECT TRANSLATE('[137.4,72.3]' , '[,]', '( )');
Result: '(137.4 72.3)'

SELECT TRANSLATE('(137.4 72.3)' , '( )', '[,]');
Result: '[137.4,72.3]'

❮ SQL Server Functions