Syntax |
LEFT(Text, Number of characters) |
Description |
Returns the specified number of characters in the supplied text, counting from the left. |
Example |
LEFT ("Personalized Printing", 6) => Person |
Text |
Any text expression or data field containing a text. |
Number of characters |
Numeric expression or data field containing the number of characters to get. |
This function allows you to print a number of characters, counting from the left side of the value in the defined database field.
You can use this function to separate field content or to create a unique code with parts of someone's name.