FileMaker allows you to use SQL commands to mine a database for very specific sets of information as well as to import information from an ODBC database.
FileMaker gives you several options for incorporating ODBC data and queries into your work. You can open a database and write a query on the fly to get or give information. You can put SQL statements into text files to quickly build a query, or you can use the Execute SQL query step within a multistep script to allow users who would normally run screaming from SQL syntax to access and use ODBC data.
Although smart quotes (sometimes called curly quotes) are more attractive and professional looking in text than simple straight quotes, they can wreak havoc if they find their way into a script statement or an SQL query, because they won't be recognized properly. Go to File > File Options, and select the Text tab. Uncheck "Use smart quotes" (Figure 13.17) before you interact with an ODBC data source.