MSSQL
Syntax:
RIGHT(String, n)Where string is the string to retrieve rightmost characters from, and n is the number of characters to retrieve.
Example:
select RIGHT('This is demo',3)
----------------------
emo
The RIGHT function returns the specified number of characters from the right of a given string. Its functionality is the same in both MSSQL and MySQL.
Syntax:
RIGHT(String, n)Where string is the string to retrieve rightmost characters from, and n is the number of characters to retrieve.
Example:
select RIGHT('This is demo',3)
----------------------
emo
It's similar to the MSSQL RIGHT function.
Example:
mysql> select RIGHT('This is demo',3);
+--------------------------+
| RIGHT('This is demo',3) |
+--------------------------+
| emo |
+--------------------------+