I am trying to search a field (Caption) in a table.
I know there is (Joey Owens) in the database.
If i type the edit box (Joey Owens) it will find that record just fine.
If i type in Joey by itself it will not find that record.
If I type in Owens by itself it will not find that record.
How can I locate that record by just useing Joey Or Owens ?
with dataModule2.SearhQuery do begin
SQL.Add('SELECT * FROM Events WHERE Caption =:Name');