Re: SQL Question

[rob@xxxxxxxxx]

> CREATE TABLE QTEMP.YOUNG (CHECKTHIS CHAR (1 ) NOT NULL WITH DEFAULT)
  Table YOUNG created in QTEMP. 
> INSERT INTO QTEMP.YOUNG VALUES('A') 
> INSERT INTO QTEMP.YOUNG VALUES('B')
  1 rows inserted in YOUNG in QTEMP. 
> INSERT INTO QTEMP.YOUNG VALUES('C')
  1 rows inserted in YOUNG in QTEMP. 
> select checkthis, 
         case CheckThis 
           when 'A' then '1' 
           when 'B' then '1' 
           else '0' 
           end as IndicatorChk
  from qtemp.young 
....+....1....+....2...
CHECKTHIS  INDICATORCHK
    A           1 
    B           1 
    C           0 
********  End of data 

Rob Berendt