@Matt Bernstein maybe try union all? union will de-dupe the results, so perhaps it is refusing to search for duplicates when long text fields are included?

that worked. Thanks!

Smart. Makes sense since you also cannot GROUP on long text I don’t think

glad that worked!