Previously, my app did all case insensitive searches. I'm now seeing that some searches are case sensitive. From what little is in the documentation (actually nothing!) I see that ILIKE is the thing to use when you want non case sensitive searches. What I am not understanding is why LIKE sometimes works for me and sometimes not.
When I do this query:
SELECT tblAlbums.cTitle FROM tblAlbums WHERE tblAlbums.cTitle Like '%after%'
I get no hits for any cTitle containing the word "After". Changing to ILIKE correctly returns these entries.
But, when I search for the beginning of the string as so:
SELECT tblAlbums.cTitle FROM tblAlbums WHERE tblAlbums.cTitle LIKE 'after%'
I do get the titles that begin with the capitalized word After. Changing to ILIKE returns the same entries. In this case LIKE and ILIKE work the same way.
Does ILIKE only apply to searches that look for embedded strings?
Is there any comprehensive explanation in the Valentina Documentation that I am not seeing? Search is not providing anything substantial.