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