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
{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.