I'd like to set the Filter property of a TTable object to include the
LIKE operator, as in:

Zone LIKE '44%'

or similar (assuming % is the wildcard character). This exact WHERE
clause works fine in SQL Explorer against the same database.

I actually want to set Table1.Filter in code but even entering it into
the object inspector doesn't work. No problems using Zone = '442' or
something like that - it works fine.

I'm using Delphi 3.0.

Any ideas?  Please e-mail me directly at stu...@ozemail.com.au