Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 22 Oct 2001 @ 21:27:54 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: SQL Question (see red line below)
 
From:   Thomas F. Stanek

Tony,

I've used the approach mentioned by Yonina with success before. What error message are you getting? Is it possible that the zero value in the ELSE portion if the case statement is actually the letter 'O'? Otherwise, the following syntax should work:

SELECT CASE WHEN TABLEKIND EQ 'V'
            THEN 1
            ELSE 0
            END     (INTEGER) AS TBL_KIND
  FROM DBC.TABLES

Regards,

Thomas F. Stanek
TFS Consulting



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016