Filemaker Loose Query

Question

hi everyone,

In SQL based db's, I'm able to perform a "loose" query by appending e.g. %taxi% and consiquently get an entry containing taxi in it (e.g. w10taxi or taxiAirport or parcelTaxi).

How do I do this in FMP? (I've tried ~taxi but this appears not to work)

I'd appreciate any help. thanks in advance Giles

Answer 1

Use *taxi. Also check help, there's many other wildcards. The ~ you used is specific to Japanese language.