cExpression

Specifies the character expression from which LEFTC(В ) returns characters.

nExpression

Specifies the number of characters returned from the character expression. If nExpression is greater than the length of cExpression, all of the character expression is returned. The empty string is returned if nExpression is negative or 0.

Character

LEFTC(В ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, LEFTC(В ) is equivalent to LEFT(В ).

LEFTC(В ) returns a specified number of characters from a character expression containing any combination of single-byte and double-byte characters.

LEFTC(В ) is identical to SUBSTRC(В ) with a starting position of 1.

This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.