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