Querying on a Notes field and not finding the expected results? It's possible that your query isn't matching the case (ie. data versus DATA) of the data you're looking for.
The Query tool does offer case-specificity in this scenario, simply because some users DO wish to only search for a certain case for this. Keep in mind, you can always add multiple Query conditions to accommodate for the various case-possibilities (again, data versus DATA).