BeginsWith

Returns 1 if a text string begins with a specified text pattern. If the text string does not begin with the pattern, the function returns 0.

For the definition and syntax of the Begins with comparison operator, see Begins With.

Syntax

BeginsWith(String, Pattern)

Where:

• String is the string that is being searched. You can use facts, metrics, columns, or string values.
• Pattern is the string that is being searched for at the beginning of the values from String. You can use facts, metrics, columns, or string values.

The text pattern comparison may or may not be case sensitive depending on the database implementation.

Example

BeginsWith(Region@DESC, "North")

Returns 1 for Regions that start with North, such as Northeast and Northwest.