Please add the IN operator as a delegable function for SharePoint Lists, because there is actual no alternative to search for a substring in big SharePoint Lists (>100000 items).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.