SQL Server TRANSLATE() Function
Clash 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 SundayTry 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
