starts_with()

Returns true if the string starts with the specified characters.

starts_with(string, prefix)

Returns true if string starts with prefix, otherwise returns false. String comparison is case-sensitive. If any of the parameters are null, then the function returns null. If prefix is an empty string, then the function returns null.

Suppose that you want to count the opportunities where the owner role starts with “Sales”. Use starts_with() in a case statement.

The resulting chart shows the number of opportunities where the owner role starts with “Sales”, grouped by owner role.