Your original query did not work because you used the AND operator. You told Oracle to only list rows that started with the letters A and B at the same time. A row can only start with one letter, right, so there's no way a row can start with two different letters at the same time. The solution is to change the operator to OR. Changing the operator to OR solves that problem but it creates a new problem: if you mix AND and OR operators then you must consider the rules of precedence. For these reasons tonkuma's solution is correct.