7.1
2013-09-23

LEFT

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

Parameter description

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.