SUBSTRING (Report Builder)

Returns a substring from within a string.

Syntax

SUBSTRING(string, start, length)

string	Specifies the string from which a substring is extracted.
start	Specifies the start position within the string.
length	Specifies the number of characters.

Example

Formula	Result
SUBSTRING(Address Line, 5, 20)	Returns a substring for each instance of the Address Line field that begins at the fifth character of the string and ends at the 20th character. For example, the following string: "#9900 2700 Production Way" returns the following substring: "0 2700 Production Wa".
SUBSTRING("lavender", 3, 5)	"vende"

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