SQL search case sensitive

[zyklotrop]

Hi,

I am trying to search a FileMaker 11 database with a SQL statement shared via ODBC using Microsoft Query and directly via the 360 Works Scriptmaster Plugin.

The query is:

SELECT A_kfWertID FROM DataAdrELEMENTE WHERE AdrElementWert Like '%GmbH%' AND AdrAttributLevel = 3

I encounter the problem that searching in a FileMaker table with SQL statements seem to be case sensitive. Searching for '%GmbH%' returns a proper result, while '%Gmbh%' or '%gmbh%' gives an empty result, apparently because the records all have the value "GmbH". According to my information MySQL on the other hand is insensitive for uppercase/lowercase search terms. Is the SQL engine in FileMaker 11 case sensitive? Is there a way to create a query that gives a result, without reference to upper or lowercase characters in the search term?

Thanks,

Martin