I tried this:

SELECT
GIFTCARD_DETAIL.GCD_DATE,
GIFTCARD_DETAIL.GCD_VALUE,
GIFTCARD_DETAIL.GCD_POSNUMBER,
GIFTCARD_DETAIL.GCD_STATUS,
CASE GIFTCARD_DETAIL.GCD_STATUS
WHEN 100 THEN cast('Fulført' as varchar(100) )
WHEN 255 THEN cast('Annulleret' as varchar(100) CHARACTER SET UTF8)
WHEN 250 THEN cast('Limbo' as varchar(100) CHARACTER SET UTF8)
else cast('Ukendt' as varchar(100) CHARACTER SET UTF8)
end as Status_Text
FROM
GIFTCARD_DETAIL
Where
GIFTCARD_DETAIL.GIFTCARD_ID = :ID
Order by GIFTCARD_DETAIL.GCD_DATE

Which still came up with the MALFORMED STRING




Miv