Hi!
I try to use a CASE -statement in the Freehand SQL but get stucked with the coding;

select
"VBUK-UVALL" AS "Header Status",
CASE "VBUK-UVALL"
WHEN 'A' THEN 'Incomplete'
ELSE 'Complete'
END AS "ColumnA"
from "Local"."INFOSET"."ZCA_TESTAR"

Can anyone help me out?

All the best
Anders