### Starts with operator

Basic and Crystal syntax.

The startsWith operator is useful for selecting records to include or exclude from your report.

##### Usage

x startsWith y
{fieldname} startsWith "abc"

This operator tests to see if the contents of {fieldname} start with a character string that you specify: "abc". If the contents of the field do start with "abc", then the formula returns the value True. If the field starts with anything else, the formula returns False.

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`{customer.CUSTOMER NAME} startsWith "A"`

TRUE, where {customer.CUSTOMER NAME} = ABC Ltd.

`{customer.CUSTOMER NAME} startsWith "C"`

FALSE, where {customer.CUSTOMER NAME} = ABC Ltd.

`{customer.CUSTOMER NAME} startsWith "ABC"`

TRUE, where {customer.CUSTOMER NAME} = ABC Inc. or ABC Ltd.

`{customer.CUSTOMER NAME} startsWith "ABC"`

FALSE, where {customer.CUSTOMER NAME} = XYZ Inc.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com