There is a function named RIGHT in MS SQL Server which returns the right part of a character string with the specified number of characters.
Syntax:
RIGHT ( string , No_of_Character )
Example:
SELECT RIGHT(‘The quick brown fox jumps over a little lazy dog.’, 23)
Output:
over a little lazy dog.
