He - sorry.

Still the same with this SQL


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) CHARACTER SET UTF8)
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

:)
I was written as above in the program :)

--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@...> wrote:
>
> No, what I meant was:
>
> what happens if you use:
>
> CASE GIFTCARD_DETAIL.GCD_STATUS
> WHEN 100 THEN cast('Fulført' as varchar(100) CHARACTER SET UTF8 )
> ^^^^^^^^^^^^^^^^^^
> 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
>
> You did the charcater set in every when clause BUT the one for "Fulført"
>
> Luc.
>