LEFT (Report Builder)
Returns the left most characters of a string.
Syntax
LEFT(string, length)
string |
Specifies the string from which to obtain the left-most characters. |
length |
Specifies the number of characters to obtain. |
Example
Formula | Result |
---|---|
LEFT(Description, 10) |
Returns the first 10 characters from each instance of the Description field. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)