Out of the box, FileMaker is a really easy solution for inputing data and simply finding the results you want when searching that data.
There are, however, times when you need to break away from FileMaker's "solve all" solution of case insensitive searching. Times where you simply want to present some data within your user interface - without setting up extra relationships or fields. Or, those times when you simply need to search based on the case sensitivity of the data within a field.
In order to accomplish this, there are pretty much two different methods. In this video I show you how to accomplish this both natively and using the ExecuteSQL method. Using ExecuteSQL we gain a number of benefits and only need to be familiar enough with composing a SQL statement that will get us what we need.
Click the title or link to this article to view the video.