LEFT returns the first character or characters in a text string, based on the number of characters you specify.
LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.
See more Functions
IMPORTANT: LEFTB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LEFTB behaves the same as LEFT, counting 1 byte per character.
The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.
- LEFT(text, [num_chars])
- LEFTB(text, [num_bytes])
The function syntax has the following arguments:
- Text Required. The text string that contains the characters you want to extract.
- Num_chars Optional. Specifies the number of characters you want LEFT to extract.
Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, LEFT returns all of text.
If num_chars is omitted, it is assumed to be 1.
Num_bytes Optional. Specifies the number of characters you want LEFTB to extract, based on bytes.