STARTSWITH

Returns whether the string starts with the specified search text.

Syntax

bool STARTSWITH(string searchText, string value)

Example

In this example we keep track of items that have been stock checked by adding "Valid_" to the start of the ProductName. We want to see if the products in our list have all been stock checked:

STARTSWITH("Valid_", ProductName)

This will return true for all ProductName's that have "Valid_" at the start and false for those that do not.