Description
Returns the leftmost characters from the specified text string.
Syntax
LEFT ( text [, num_chars] )
| Parameter | Description |
|---|---|
| text | Any text string. |
| num_chars | The number of characters to return. This value must be greater
than or equal to zero. If num_chars is greater than the number of characters in text, the entire string is returned. Omitting this argument assumes a value of 1. |
Examples
This function returns 2:
LEFT("2nd Quarter")
This function returns 2nd:
LEFT("2nd Quarter", 3)
See also