hi tdatgod,
yes, this is the sql. I think it's kinda complicated.. :-)
sel CASE
WHEN substring(T1."seizoen" from 3 for 1) = 'Z'
THEN ('Zomer') ELSE ('Winter')
END,
T2."Landcode" || ' - ' || T3."landnaam",
T1."objectnummer" || ' - ' || T2."Omschrijving"...