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.

Share this: