Syntax
StartsWith(Text, StartText)Examples
Filter(Contacts, StartsWith(FullName, txtSearch.Text))Contacts whose name starts with the search
Maker notes
- Not case-sensitive. Often delegable, which makes it a good choice for search boxes.
StartsWith
Checks whether a string begins with another string.