ich hätte noch
Code: Alles auswählen
SELECT "NUMMER", "ja-nein" AS "Orig", CASE WHEN "ja-nein" = TRUE THEN CHAR( 9745 ) WHEN "ja-nein" = FALSE THEN CHAR( 9744 ) WHEN "ja-nein" IS NULL THEN CHAR( 9949 ) ELSE 0 END AS "Ersatz" FROM "meineDB" WHERE "NUMMER" < 4 ORDER BY "NUMMER"