Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 22 Oct 2001 @ 19:29:15 GMT


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


Subj:   Re: SQL question (see red line below)
 
From:   Geoffrey Rommel

  In the following query, I want the result of the CASE which is put into "FLAG" to be an INTEGER field.  



Why do you need to do this? All the results given in your THEN clauses are integers, so the end result of your CASE expression should be an integer.



     
  <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: 15 Jun 2023