Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 18:20:03 GMT

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

It works.

     create volatile table t1
     (
     the_value char(1)
     )
     on commit preserve rows
     ;

     insert into t1 values('1');
     insert into t1 values('2');
     insert into t1 values('3');
     insert into t1 values('4');
     insert into t1 values('5');


     select * from t1 where the_value between '2' and '5';

Vince Bernard
Teradata DBA

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