RIGHT(string,length[,pad]) In a similar manner to LEFT, this function returns the rightmost "length" characters of string. If the string is too short then it is padded on the left with spaces, or with the pad character if this is supplied.