FIND (Report Builder)

Position of the first instance of a substring.

Syntax

FIND(string, substring)

string	Specifies the string that contains the substring for which to search.
substring	Specifies the substring to locate.

Remarks

• If the string is not found, a zero is returned.

Example

Formula	Result
FIND("A light yet stiff aluminum bar for long distance riding.", "aluminum bar")	Returns the number of character spaces within the string that the substring begins. In this example, 19.
FIND(Description, "aluminum")	Returns a list of values that indicates the number of character spaces within the string that the substring begins, similar to the following: 10 19 0

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