IsNull
Diese Funktion prüft, ob der erste Ausdruck Null ist. Falls nein, wird der erste Ausdruck zurückgegeben, falls
ja, wird der zweite Ausdruck ausgewertet. Beide Ausdrücke müssen vom gleichen Datentyp sein.
Syntax
IsNull (<zu prüfender Ausdruck>, <Ersatzausdruck>)
Parameterliste
- <zu prüfender Ausdruck>
- Ausdruck, bei welchem geprüft wird, ob er gleich Null ist
- <Ersatzausdruck>
- Ausdruck, der zurückgegeben wird, falls der erste Ausdruck Null darstellt
- Rückgabewert
- entweder <zu prüfender Ausdruck> oder <Ersatzausdruck>
- Typ
- sonstige Funktion
Beispiele
Die Funktion kann zum einen dafür verwendet werden, die Null-Behandlung zu vereinfachen. Man denke an eine Haupttabelle
<Personen> und an eine Randtabelle <Personentitel> (Dr., Dr.med. usw.). Die Haupttabelle ist über einen
Left Join mit der Randtabelle verknüpft, da es Personen ohne Titel gibt. Soll als Text
<optionaler Titel plus Leerzeichen> <Personenname>
ausgegeben werden, so erzeugt die direkte Verknüpfung
B.Titel + ' ' + A.Personenname
Null für alle Personen ohne Titel, da jede Verknüpfung mit Null selbst zu Null ausgewertet wird. Eine Abhilfe schafft hier die
IsNull-Funktion:
IsNull(B.Titel + ' ', '') + A.Personenname
Ist B.Titel Null, so auch B.Titel + ' ', also wird nur ein Leerstring eingefügt, ansonsten wird die gewünschte Darstellung erzeugt.
Eine zweite Verwendungsmöglichkeit besteht darin, bei der Nutzung von Aggregatfunktionen mit der IsNull-Funktion Standardwerte
für jene Zellen einzufügen, die leer sind. Aggregatfunktionen ignorieren üblicherweise Null-Werte.
Man betrachte die folgende
Tabelle:
Die folgende Liste zeigt die verschiedenen Rückgabewerte
Aggregat | Ergebnis | Hinweise |
---|
Count(*) | 4 | Count(*) zählt immer alle Zeilen |
Count(Eintrag) | 3 | Count(<Spaltenname>) zählt nur die Zeilen <> Null |
Count(IsNull(Eintrag, 0)) | 4 | Die Zelle = Null wird mit 0.0 belegt und mitgezählt |
Sum(Eintrag) | 3.0 | = 0.0 + 1.0 + 2.0 |
Sum(IsNull(Eintrag, 0)) | 3.0 | = 0.0 + 1.0 + 2.0 + 0.0 |
Avg(Eintrag) | 1.0 | = (0.0 + 1.0 + 2.0) / 3 |
Avg(IsNull(Eintrag, 0)) | 0.7500 | = (0.0 + 1.0 + 2.0 + 0.0) / 4 |
Falls ein Standardwert inhaltlich sinnvoll ist, kann er auf diese Weise ad hoc eingefügt werden, ohne daß die Grunddaten
per Update-Befehl verändert werden müssen. Bei einer Aggregatfunktion, welche auf die Zahl der gefundenen Zeilen bezug nimmt (Avg (Mittelwert) = Summe / Anzahl der Zeilen)
verändert sich das Ergebnis. Werden bsp. Artikel ohne Preisauszeichnung mit dieser Technik auf einen Preis von 0.0 gesetzt,
so verringert sich nun der Durchschnittspreis. In solchen Fällen ist die direkte Auswertung mit Avg(<Spalte>), welche
die Nullwerte sowohl beim Addieren der Werte als auch bei der Berechnung der Anzahl der ausgewerteten Zeilen ignoriert, sinnvoller.
Hinweise
Der Name dieser Funktion ist etwas mißverständlich. Angesichts der
IsDate
- und der
IsNumeric
-Funktionen
könnte erwartet werden, daß sie 1 bzw. 0 zurückliefert, falls der (einzige) Parameter Null ist. Sie liefert jedoch nicht
0/1, sondern entweder den ersten oder den zweiten Parameter zurück.
Die Funktion ist eine verkürzte Version der
Case
-Verzweigung und könnte durch den folgenden Ausdruck
ersetzt werden:
Case
When <zu prüfender Ausdruck> Is Null Then <Ersatzausdruck
Else <zu prüfender Ausdruck>
End
%22%20viewport-fill-opacity=%221%22%20fill=%22rgb(0,0,0)%22%20fill-opacity=%221%22%20style=%22background-color:rgb(255,255,255);background-color:rgba(1);%22%3E%3Crect%20x=%224%22%20y=%224%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%224%22%20y=%2213%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2215%22%20width=%223%22%20height=%222%22/%3E%3Crect%20x=%224%22%20y=%2218%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%224%22%20y=%2221%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2223%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2225%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%224%22%20y=%2230%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%224%22%20y=%2233%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2235%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2237%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2240%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%224%22%20y=%2242%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%225%22%20y=%224%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2210%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2214%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%225%22%20y=%2218%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2220%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%225%22%20y=%2226%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2228%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%225%22%20y=%2231%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2239%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2242%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%225%22%20y=%2248%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%226%22%20y=%226%22%20width=%223%22%20height=%223%22/%3E%3Crect%20x=%226%22%20y=%2213%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%226%22%20y=%2217%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%226%22%20y=%2224%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%226%22%20y=%2228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%226%22%20y=%2230%22%20width=%225%22%20height=%221%22/%3E%3Crect%20x=%226%22%20y=%2244%22%20width=%223%22%20height=%223%22/%3E%3Crect%20x=%227%22%20y=%2214%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%227%22%20y=%2219%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%227%22%20y=%2222%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%227%22%20y=%2225%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%227%22%20y=%2227%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%227%22%20y=%2229%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%227%22%20y=%2232%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%227%22%20y=%2240%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%228%22%20y=%2215%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%228%22%20y=%2221%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%228%22%20y=%2224%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%228%22%20y=%2231%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%228%22%20y=%2235%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%228%22%20y=%2238%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%229%22%20y=%2212%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%229%22%20y=%2217%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%229%22%20y=%2219%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%229%22%20y=%2222%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%229%22%20y=%2224%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%229%22%20y=%2228%22%20width=%227%22%20height=%221%22/%3E%3Crect%20x=%229%22%20y=%2232%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%229%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%225%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2210%22%20y=%2212%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2214%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2216%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2218%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2232%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2234%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2236%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2238%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2240%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2210%22%20y=%2243%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2211%22%20y=%2217%22%20width=%222%22%20height=%223%22/%3E%3Crect%20x=%2211%22%20y=%2221%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2211%22%20y=%2223%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2211%22%20y=%2229%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2211%22%20y=%2231%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2211%22%20y=%2233%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2211%22%20y=%2235%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2212%22%20y=%224%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2212%22%20y=%226%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2212%22%20y=%228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2212%22%20y=%2210%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2212%22%20y=%2213%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2212%22%20y=%2215%22%20width=%221%22%20height=%2215%22/%3E%3Crect%20x=%2212%22%20y=%2234%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2212%22%20y=%2239%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2212%22%20y=%2243%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%225%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2213%22%20y=%229%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2212%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2213%22%20y=%2215%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2217%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2222%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2213%22%20y=%2230%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2232%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2236%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2238%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2213%22%20y=%2244%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2213%22%20y=%2247%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%227%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2214%22%20y=%2210%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2220%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2214%22%20y=%2223%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2229%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2233%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2240%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2214%22%20y=%2243%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2214%22%20y=%2246%22%20width=%223%22%20height=%222%22/%3E%3Crect%20x=%2215%22%20y=%226%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2215%22%20y=%229%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2215%22%20y=%2211%22%20width=%225%22%20height=%221%22/%3E%3Crect%20x=%2215%22%20y=%2214%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2215%22%20y=%2219%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2215%22%20y=%2225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2215%22%20y=%2235%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2215%22%20y=%2238%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2215%22%20y=%2241%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2216%22%20y=%224%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2216%22%20y=%228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2216%22%20y=%2210%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2216%22%20y=%2230%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2216%22%20y=%2234%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2216%22%20y=%2240%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2216%22%20y=%2242%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2216%22%20y=%2245%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2217%22%20y=%225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%229%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%2216%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%2218%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%2222%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2217%22%20y=%2225%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2217%22%20y=%2229%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2217%22%20y=%2234%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2217%22%20y=%2237%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2217%22%20y=%2243%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2218%22%20y=%224%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2218%22%20y=%226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2218%22%20y=%228%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2218%22%20y=%2214%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2218%22%20y=%2221%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2218%22%20y=%2223%22%20width=%223%22%20height=%222%22/%3E%3Crect%20x=%2218%22%20y=%2226%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2218%22%20y=%2231%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2218%22%20y=%2238%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2218%22%20y=%2241%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2218%22%20y=%2247%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2219%22%20y=%2213%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2219%22%20y=%2217%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2219%22%20y=%2225%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2219%22%20y=%2228%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2219%22%20y=%2232%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2219%22%20y=%2240%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2219%22%20y=%2243%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2219%22%20y=%2245%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%224%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%226%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%229%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2220%22%20y=%2212%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2215%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2218%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2222%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2220%22%20y=%2226%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2220%22%20y=%2230%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2220%22%20y=%2233%22%20width=%223%22%20height=%223%22/%3E%3Crect%20x=%2220%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2239%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2220%22%20y=%2241%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2220%22%20y=%2247%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2221%22%20y=%225%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2221%22%20y=%229%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2221%22%20y=%2216%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2221%22%20y=%2221%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2221%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2221%22%20y=%2228%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2221%22%20y=%2232%22%20width=%222%22%20height=%224%22/%3E%3Crect%20x=%2221%22%20y=%2238%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2221%22%20y=%2245%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2221%22%20y=%2248%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2222%22%20y=%227%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2222%22%20y=%2210%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2222%22%20y=%2214%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2222%22%20y=%2219%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2222%22%20y=%2223%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2222%22%20y=%2225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2222%22%20y=%2228%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2222%22%20y=%2236%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2222%22%20y=%2242%22%20width=%223%22%20height=%222%22/%3E%3Crect%20x=%2223%22%20y=%229%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2223%22%20y=%2211%22%20width=%222%22%20height=%223%22/%3E%3Crect%20x=%2223%22%20y=%2217%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2223%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2223%22%20y=%2229%22%20width=%223%22%20height=%222%22/%3E%3Crect%20x=%2223%22%20y=%2232%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2223%22%20y=%2236%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2223%22%20y=%2239%22%20width=%222%22%20height=%227%22/%3E%3Crect%20x=%2223%22%20y=%2248%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2224%22%20y=%226%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2224%22%20y=%228%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2224%22%20y=%2219%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2224%22%20y=%2221%22%20width=%221%22%20height=%2211%22/%3E%3Crect%20x=%2224%22%20y=%2237%22%20width=%221%22%20height=%229%22/%3E%3Crect%20x=%2224%22%20y=%2247%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2225%22%20y=%224%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2225%22%20y=%2212%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2225%22%20y=%2218%22%20width=%222%22%20height=%224%22/%3E%3Crect%20x=%2225%22%20y=%2224%22%20width=%227%22%20height=%221%22/%3E%3Crect%20x=%2225%22%20y=%2228%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2225%22%20y=%2232%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2225%22%20y=%2240%22%20width=%228%22%20height=%221%22/%3E%3Crect%20x=%2225%22%20y=%2244%22%20width=%228%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%224%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2226%22%20y=%228%22%20width=%225%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2210%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2214%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2226%22%20y=%2222%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2228%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2230%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2234%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2226%22%20y=%2238%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2226%22%20y=%2242%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2226%22%20y=%2245%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2227%22%20y=%2213%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2227%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2227%22%20y=%2223%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2227%22%20y=%2231%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2227%22%20y=%2236%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2227%22%20y=%2239%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2227%22%20y=%2246%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2228%22%20y=%224%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2228%22%20y=%229%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2228%22%20y=%2216%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2228%22%20y=%2221%22%20width=%221%22%20height=%228%22/%3E%3Crect%20x=%2228%22%20y=%2233%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2228%22%20y=%2241%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2228%22%20y=%2247%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%229%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2211%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2215%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2217%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2219%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2229%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2231%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2229%22%20y=%2234%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2229%22%20y=%2237%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2229%22%20y=%2246%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2230%22%20y=%226%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2230%22%20y=%2210%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2230%22%20y=%2212%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2230%22%20y=%2218%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2230%22%20y=%2221%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2230%22%20y=%2228%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2230%22%20y=%2232%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2230%22%20y=%2235%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2230%22%20y=%2245%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%225%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%227%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%2211%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%2216%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%2219%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%2222%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%2226%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%2231%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%2233%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%2236%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2231%22%20y=%2241%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2231%22%20y=%2243%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2232%22%20y=%224%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2232%22%20y=%228%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2232%22%20y=%2213%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2232%22%20y=%2215%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2232%22%20y=%2220%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2232%22%20y=%2227%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2232%22%20y=%2232%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2232%22%20y=%2234%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2232%22%20y=%2238%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2232%22%20y=%2242%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2232%22%20y=%2245%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2233%22%20y=%226%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2211%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2214%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2233%22%20y=%2219%22%20width=%228%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2221%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2223%22%20width=%225%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2227%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2233%22%20y=%2236%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2233%22%20y=%2246%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2234%22%20y=%224%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2234%22%20y=%229%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2234%22%20y=%2213%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2234%22%20y=%2218%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2234%22%20y=%2222%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2234%22%20y=%2226%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2234%22%20y=%2230%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2234%22%20y=%2239%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2234%22%20y=%2242%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2234%22%20y=%2246%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%227%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2235%22%20y=%2212%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%2214%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%2220%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%2224%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2235%22%20y=%2228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%2230%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2235%22%20y=%2235%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2235%22%20y=%2240%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2235%22%20y=%2248%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2236%22%20y=%227%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2236%22%20y=%2210%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2236%22%20y=%2216%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2236%22%20y=%2221%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2236%22%20y=%2229%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2236%22%20y=%2233%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2236%22%20y=%2236%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2236%22%20y=%2241%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2236%22%20y=%2244%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2237%22%20y=%2214%22%20width=%221%22%20height=%228%22/%3E%3Crect%20x=%2237%22%20y=%2224%22%20width=%229%22%20height=%221%22/%3E%3Crect%20x=%2237%22%20y=%2226%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2237%22%20y=%2232%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2237%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2237%22%20y=%2239%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2237%22%20y=%2242%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2238%22%20y=%228%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2238%22%20y=%2210%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2238%22%20y=%2212%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2238%22%20y=%2214%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2238%22%20y=%2222%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2238%22%20y=%2225%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2238%22%20y=%2231%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2238%22%20y=%2242%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2238%22%20y=%2246%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2239%22%20y=%225%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2239%22%20y=%2211%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2239%22%20y=%2216%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2239%22%20y=%2221%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2239%22%20y=%2233%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2239%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2239%22%20y=%2239%22%20width=%222%22%20height=%225%22/%3E%3Crect%20x=%2239%22%20y=%2245%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2239%22%20y=%2247%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2240%22%20y=%224%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2240%22%20y=%227%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2240%22%20y=%2210%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2240%22%20y=%2215%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2240%22%20y=%2217%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2240%22%20y=%2223%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2240%22%20y=%2234%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2240%22%20y=%2238%22%20width=%221%22%20height=%229%22/%3E%3Crect%20x=%2241%22%20y=%2214%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2241%22%20y=%2221%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2241%22%20y=%2223%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2241%22%20y=%2228%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2241%22%20y=%2230%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%2241%22%20y=%2238%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2241%22%20y=%2240%22%20width=%228%22%20height=%221%22/%3E%3Crect%20x=%2241%22%20y=%2244%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2242%22%20y=%224%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%2242%22%20y=%2212%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2242%22%20y=%2219%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2242%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2242%22%20y=%2229%22%20width=%225%22%20height=%221%22/%3E%3Crect%20x=%2242%22%20y=%2231%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2242%22%20y=%2233%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2242%22%20y=%2239%22%20width=%222%22%20height=%222%22/%3E%3Crect%20x=%2242%22%20y=%2242%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2242%22%20y=%2244%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%224%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%2210%22%20width=%226%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%2213%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%2215%22%20width=%222%22%20height=%223%22/%3E%3Crect%20x=%2243%22%20y=%2219%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2243%22%20y=%2230%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2243%22%20y=%2235%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%2245%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2243%22%20y=%2248%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2244%22%20y=%226%22%20width=%223%22%20height=%223%22/%3E%3Crect%20x=%2244%22%20y=%2212%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2244%22%20y=%2222%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2244%22%20y=%2225%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%2244%22%20y=%2241%22%20width=%221%22%20height=%225%22/%3E%3Crect%20x=%2244%22%20y=%2247%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2245%22%20y=%2213%22%20width=%224%22%20height=%221%22/%3E%3Crect%20x=%2245%22%20y=%2215%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2245%22%20y=%2218%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2245%22%20y=%2225%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2245%22%20y=%2227%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2245%22%20y=%2234%22%20width=%221%22%20height=%224%22/%3E%3Crect%20x=%2245%22%20y=%2241%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2245%22%20y=%2246%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2246%22%20y=%2212%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2246%22%20y=%2216%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2246%22%20y=%2223%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2246%22%20y=%2228%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2246%22%20y=%2233%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2246%22%20y=%2237%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2246%22%20y=%2241%22%20width=%223%22%20height=%221%22/%3E%3Crect%20x=%2246%22%20y=%2243%22%20width=%222%22%20height=%223%22/%3E%3Crect%20x=%2247%22%20y=%2214%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2218%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2220%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2226%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2228%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2230%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2232%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2235%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2247%22%20y=%2238%22%20width=%222%22%20height=%221%22/%3E%3Crect%20x=%2247%22%20y=%2242%22%20width=%221%22%20height=%227%22/%3E%3Crect%20x=%2248%22%20y=%225%22%20width=%221%22%20height=%226%22/%3E%3Crect%20x=%2248%22%20y=%2212%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2248%22%20y=%2215%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2248%22%20y=%2221%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2248%22%20y=%2223%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2248%22%20y=%2225%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2248%22%20y=%2227%22%20width=%221%22%20height=%221%22/%3E%3Crect%20x=%2248%22%20y=%2234%22%20width=%221%22%20height=%222%22/%3E%3Crect%20x=%2248%22%20y=%2239%22%20width=%221%22%20height=%223%22/%3E%3Crect%20x=%2248%22%20y=%2246%22%20width=%221%22%20height=%222%22/%3E%3C/svg%3E)
Link zur hiesigen Seite als QR-Code
Kontaktformular:
Schreiben Sie mir und wir bauen gemeinsam Ihre neue Web-Datenbank!
© 2003-2023 Jürgen Auer, Berlin.