Using SQL 'Like' Conditions in TDataset Filters

In Delphi, you can emulate an SQL LIKE condition using a TDataset Filter by using an asterisk wildcard characters. For example:

SQL -- WHERE FirstName Like %JOHN% (will return JOHN and JOHNNY)
Filter -- Firstname = '*JOHN*'