Right String Function In SQL Server 2008
In this article i will explain how to use the Right string function.
Returns the rightmost part of a character string str with the given number of characters. LEFT string function takes 2 arguments.
string- String value (field name or expression) that will be used as input string.
length- Specifies the number of characters to obtain from the String you provided.
Suppose we have table named Employee as.
Returns the four rightmost characters of the first name for each employee.