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