SQL Server – RIGHT () function
Right():-
This function returns the specified number of characters from the Right part of the given character string.
Syntax:-
Select RIGHT ( character_expression , integer_expression )
For example, the below query will return two characters from the last.
Select RIGHT(‘Vivek’,2)
Result
ek
27 thoughts on “RIGHT() function in SQL Server”