Make your own free website on Tripod.com
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’



PREV NEXT