3.2.33. LEFT(string,length[,padchar]) Returns the length leftmost 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 right with <space> (or padchar if that is specified) to make it the correct length. LEFT(‘Foo bar’, 5) –> ‘Foo b’ LEFT(‘Foo bar’, 3) –> ‘Foo’ LEFT(‘Foo bar’, 10) –> ‘Foo bar ‘ LEFT(‘Foo bar’, 10, ‘*’) –> ‘Foo bar***’
PREV NEXT