ok, hab das jetzt gemacht, so sieht das
SQL-Statement aus(ein Beispiel):
SELECT * FROM Zahlungen WHERE (Restbetrag > "0")AND(((VWZ1 LIKE "%SP00001L%")OR(VWZ2 LIKE "%SP00001L%")OR(VWZ3 LIKE "%SP00001L%")OR(VWZ4 LIKE "%SP00001L%")OR(VWZ5 LIKE "%SP00001L%")OR(VWZ6 LIKE "%SP00001L%")OR(VWZ7 LIKE "%SP00001L%")OR(VWZ8 LIKE "%SP00001L%")OR(VWZ9 LIKE "%SP00001L%")OR(VWZ10 LIKE "%SP00001L%")OR(VWZ11 LIKE "%SP00001L%")OR(VWZ12 LIKE "%SP00001L%")OR(VWZ13 LIKE "%SP00001L%")OR(VWZ14 LIKE "%SP00001L%"))OR((VWZ1 LIKE "%06S0002766%")OR(VWZ2 LIKE "%06S0002766%")OR(VWZ3 LIKE "%06S0002766%")OR(VWZ4 LIKE "%06S0002766%")OR(VWZ5 LIKE "%06S0002766%")OR(VWZ6 LIKE "%06S0002766%")OR(VWZ7 LIKE "%06S0002766%")OR(VWZ8 LIKE "%06S0002766%")OR(VWZ9 LIKE "%06S0002766%")OR(VWZ10 LIKE "%06S0002766%")OR(VWZ11 LIKE "%06S0002766%")OR(VWZ12 LIKE "%06S0002766%")OR(VWZ13 LIKE "%06S0002766%")OR(VWZ14 LIKE "%06S0002766%")))
der Wert SP00001L kommt definitiv in einem Der Felder vor, aber trotzdem bekomm ich kein bzw. ein leeres Ergebnis.
Ist da was Falsch dran?