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)

Help and Information

Getting SQL Server 2005 Assistance