SQL-Abfrage mit bedingtem Where

[Pikachu]

Probier's mal so:

 
SELECT Feld1, Feld2 ....
FROM   LIB/FILE
WHERE  CASE WHEN :IKDGR    <> 0 THEN :IKDGR    ELSE KDGR    END = KDGR
AND    CASE WHEN :IVERBAND <> 0 THEN :IVERBAND ELSE VERBAND END = VERBAND
AND    CASE WHEN :IKDNR    <> 0 THEN :IKDNR    ELSE KDNR    END = KDNR
AND    ....