Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 18:48:24 GMT

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

Subj:   Re: Between Statement
From:   Dieter Noeth

Anomy.Anom wrote:

  If you have a range of values say ( 1,2,3,4,5,6,7,8,9) and they are data type char, would a statement like "select * from table where field between 3 and 6" work?  

Yes, because the column is automatically casted to an integer.

  I do not want to cast these fields as Interger.  

You don't have to, it's done automatically ;-)

Why can't you write "BETWEEN '3' and '6'"?

Because there might be '31'?

Then you datamodel is screwed.


  <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