Skip to Content
avatar image
Former Member

SAP Lumira Freehand SQL - CASE statement

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers