SQL Server TRANSLATE() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL Server TRANSLATE() Function




❮ SQL Server Functions



Example


Return the string from the first argument AFTER the characters specified in
the second argument are translated into the characters specified in the third
argument:



SELECT TRANSLATE('Monday', 'Monday', 'Sunday'); // Results in Sunday

Try it Yourself »

Definition and Usage


The TRANSLATE() function returns the string from the first argument after the
characters specified in the second argument are translated into the characters specified in the third argument.


Note: The TRANSLATE() function will return an error if characters and
translations have different lengths.



Syntax



TRANSLATE(string, characters, translations)


Parameter Values









Parameter Description
string Required. The input string
characters Required. The characters that should be replaced
translations Required. The new characters

Technical Details




Works in: SQL Server (starting with 2017)

More Examples




Example


Return the string from the first argument AFTER the characters specified in
the second argument are translated into the characters specified in the third
argument:



SELECT TRANSLATE('3*[2+1]/8-4', '', '()()'); // Results in 3*(2+1)/(8-4)

Try it Yourself »




❮ SQL Server Functions


-