This function extracts a specified number of characters from the right side of the string.
Syntax:Right(String,Length_of_characters) or Right([ColumnName],length_of_characters)
String expression from which the rightmost characters to be extracted.
Length argument tells how many characters to be extracted from the string argument. If length argument is 0 it will return a zero length string will be returned. If the string contains Null, Null is returned. If greater than or equal to the length of the string, the entire string is returned.
Right(“Access”,4) will return the string “cess”. It will extract 4 rightmost characters from the string.
Right(“Access”,10) will return the string “Access”. It extracted full string because the length of Access string is 6 and the argument supplied is more than 6.