SELECT DA.id_daten
     , DA.titel
     , DA.filmlaenge
     , DA.isbn
     , DA.erstellt
     , DA.geaendert
     , DA.sid_Genre
     , DA.sid_Format
     , FA.id_format
     , FA.format
     , GR.id_genre
     , GR.genre

FROM tbl_daten DA

LEFT OUTER JOIN tbl_format FA
ON (DA.sid_format=FA.id_Format)

LEFT OUTER JOIN tbl_genre GR
ON (DA.sid_genre=GR.id_Genre)

WHERE
      ((UPPER(titel) like :p1) OR
       (UPPER(filmlaenge) like :p1) OR
       (UPPER(isbn) like :p1) OR
       (UPPER(FA.format) like :p1) OR
       (UPPER(GR.Genre) like :p1))

{Edit.OnChange}

 V_Suchstring:=SuchEdit.Text;
 DataMod.SQL.Close;
 DataMod.SQL.Params[0].AsString :=(UPPERCASE('%'+V_Suchstring+'%'));
 DataMod.SQL.Open;