Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Aug 2007 @ 17:06:00 GMT


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


Subj:   Re: Between Statement
 
From:   Castelli Emanuel Alejandro

  I do not want to cast these fields as Interger.  


"These Fields" are the table fields or the between values?

Because if you cast the between values to integer, It should work.

An example:

     Values(1,2,3,35);

     select * from t1 where the_value between '1' and '4';

Returns:

     1,2,3,35

But:

     select *
        from t1
        where the_value between cast('1' as integer) and cast('4' as integer);

Returns:

     1,2,3,4

Why you can't cast the values to integer?

Hope this helps,


Bye

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina



     
  <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