Right String Function In SQL Server 2008
In this article i will explain how to use the Right string function.
Introduction
Returns the rightmost part of a character string str with the given number of characters. LEFT string function takes 2 arguments.
Syntax
where,
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.
Example
Suppose we have table named Employee as.
Returns the four rightmost characters of the first name for each employee.