Hi There,
I'am using Progress 9.1D
I've noticed that using multiple case statements in the same select does not work. Anybody any ideas?
SQL Statement:
The SQL Statement:
SELECT
Field1,
CAST
(
CASE
WHEN Field2 = ''
THEN NULL
ELSE Field2
END
AS VARCHAR(800)
)
AS Field2,
Field3
FROM Tablex
Does work. However, the following fails:
SELECT
Field1,
CAST
(
CASE
WHEN Field2 = ''
THEN NULL
ELSE Field2
END
AS VARCHAR(800)
)
AS Field2,
CAST
(
CASE
WHEN Field3 = ''
THEN NULL
ELSE Field3
END
AS VARCHAR(2500)
)
AS Field3
FROM Tablex
Datatypes etc are checked.