Make your own free website on
3.2.45. RIGHT(string,length[,padchar])

Returns the length rightmost characters in string. If length
(which must be a non-negative whole number) is greater than the
length of string the result is padded on the left with the
necessary number of padchars to make it as long as length
specifies. Padchar defaults to <space>.

     RIGHT(‘Foo bar’, 5)      –>   ‘o bar’
     RIGHT(‘Foo bar’, 3)      –>   ‘bar’
     RIGHT(‘Foo bar’, 10)          –>   ‘   Foo bar’
     RIGHT(‘Foo bar’, 10, ‘*’)     –>   ‘***Foo bar’