Returns a specified number of characters from the left side of a string.
Left(string, length)
The Left syntax has these arguments:
Part | Description |
---|---|
string | String expression from which the leftmost characters are returned. If string contains Null, Null is returned. |
length | Numeric expression indicating how many characters to return. If 0, a zero-length string("") is returned. If greater than or equal to the number of characters in string, the entire string is returned. |
To determine the number of characters in string, use the Len function.
Note The LeftB is used with byte data contained in a string. Instead of specifying the number of characters to return, length specifies the number of bytes.