I have the following query:
=QUERY('Data'!A2:F,"SELECT A, B, F WHERE C=''")
In column E I also have strings which correspond to last names. I want to select all rows where the string in E has more than one char. I've tried using the MATCH and LIKE operators but haven't managed to get it to work. One solution I actively avoided was using an extra column with the LEN function and select based on the values there. I would like the logic to be contained in the query as much as possible.