Using multiple case statements in same select causes error

Posted by Admin on 26-Nov-2009 17:17

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.

All Replies

This thread is closed