Поиск по параметру во всех полях таблицы

 SELECT * FROM Table1 WHERE (Pole1 LIKE :param) OR (Pole2 LIKE :param) OR (Pole3 LIKE :param) OR (Pole4 LIKE :param);

PARAMETERS param Text;
SELECT *
FROM Table1
WHERE Pole1 LIKE param OR Pole2  LIKE param OR Pole3 LIKE param OR Pole4 LIKE param

PARAMETERS param text (50);
SELECT * FROM Table1
WHERE ((Pole1 & " " & Pole2 & " " & Pole3 & " " & Pole4) LIKE "*" & param & "*");

 PARAMETERS param text (50);

   qFinanz->SQL->ADD(" select * from HomF where (Pic_st Like :ttt) or (Sl_kdd Like :ttt) or (Idd_kat Like :ttt) or (Kdd Like :ttt) or (Date_o Like :ttt) or (Date_id Like :ttt) or (Chet Like :ttt) or (Klient Like :ttt) or (Mem Like :ttt) or (Gruppa_St Like :ttt) or (Rashod Like :ttt) or (Prihod Like :ttt) or (Stat Like :ttt) order by Date_o desc;");
           frmA_Start->qFinanz->Parameters->ParamByName("ttt")->VALUE = ("%" + txtFind->Text + "%") ; //так вызывается параметр
           qFinanz->OPEN();

SELECT * FROM HomF WHERE
   (Pic_st LIKE :ttt) 
   OR (Sl_kdd LIKE :ttt) 
   OR (Idd_kat LIKE :ttt) 
   OR (Kdd LIKE :ttt) 
   OR (Date_o LIKE :ttt) 
   OR (Date_id LIKE :ttt) 
   OR (Chet LIKE :ttt) 
   OR (Klient LIKE :ttt) 
   OR (Mem LIKE :ttt) 
   OR (Gruppa_St LIKE :ttt) 
   OR (Rashod LIKE :ttt) 
   OR (Prihod LIKE :ttt) 
   OR (Stat LIKE :ttt) 
ORDER BY Date_o DESC;

SELECT * FROM TableTest WHERE 
    (RecID LIKE ttt) 
    OR (TextField01 LIKE ttt) 
    OR (DateTime01 LIKE ttt)
ORDER BY DateTime01 DESC;

SELECT * FROM TableTest WHERE 
    (RecID LIKE "*" & ttt & "*") 
    OR (TextField01 LIKE "*" & ttt & "*") 
    OR (DateTime01 LIKE "*" & ttt & "*")
ORDER BY DateTime01 DESC;

SELECT Id, [Name] FROM MSysObjects WHERE (([Id] LIKE "*" & [ttt] & "*") 
OR ([Name] LIKE "*" & [ttt] & "*") 
OR ([Name] LIKE "*odule*"));

 PARAMETERS ttt text (50);

SELECT * FROM MSysObjects;

SELECT Id, [Name] FROM MSysObjects WHERE (([Id] LIKE "*" & [ttt] & "*") 
OR ([Name] LIKE "*" & [ttt] & "*") 
OR ([Name] LIKE "*odule*"));