on 11-21-2016 8:13 AM
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.