RIGHT Function in SQL Server

RIGHT()
 
Returns the right most characters of a string.
 
Syntax 
RIGHT(string, length) 

string
Specifies the string from which to obtain the left-most characters.
 
length
Specifies the number of characters to obtain.
 
Example :
SELECT RIGHT('SoftwareEngineer',12) 
 
OutPut
wareEngineer