OpenOffice.info

SELECT "Staat", "PLZ", "Ort", CASEWHEN( "Staat" = 'D -', 'nn', 'aa' ) FROM "Ort"

Select "Staat", "PLZ", "Ort", CASE WHEN "Staat" = 'D -' THEN 'nn' WHEN "Staat" = 'E -' THEN 'aa'  ELSE 'ff' END FROM "Ort"

Weil es in der Syntax der HSQLDB 1.8. keine IF-Anweisung gibt.
Siehe auch Chapter 10. Built In Functions im [url=https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=25716#p116849]HSQL-Guide[/url]
Suchst Du eventuell etwas wie
[code]SELECT "Staat", "PLZ", "Ort", CASEWHEN( "Staat" = 'D -', 'nn', 'aa' ) FROM "Ort"[/code]
oder
[code]Select "Staat", "PLZ", "Ort", CASE WHEN "Staat" = 'D -' THEN 'nn' WHEN "Staat" = 'E -' THEN 'aa' ELSE 'ff' END FROM "Ort"[/code]
HTH R

SELECT "Vorname",
      IFNULL("Name", 'N/A') AS "Name",
      "Ort-NR"
FROM "Mitglieder"

SELECT "Vorname",
      COALESCE("Name", 'N/A') AS "Name",
      "Ort-NR"
FROM "Mitglieder"

So[code]SELECT "Vorname",
IFNULL("Name", 'N/A') AS "Name",
"Ort-NR"
FROM "Mitglieder"[/code]
besser so
[code]SELECT "Vorname",
COALESCE("Name", 'N/A') AS "Name",
"Ort-NR"
FROM "Mitglieder"[/code]
HTH R