Left(field,number)


Description

Returns the left most characters from the string where <number> represents the number of characters to extract

Example

left("Hello World", 5)
returns Hello, the five left characters in the string
left(ITT,10)
returns the ten right most characters of the item text

Related Rules

right(), substr()