![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 16 Aug 2007 @ 11:18:51 GMT
Subj: | | Re: Between Statement |
|
From: | | Dsilva, Simson |
create volatile table t1
(
the_value char(2)
)
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('23');
insert into t1 values('24');
insert into t1 values('25');
insert into t1 values('35');
select * from t1 where the_value between '2' and '5';
This will also display 23 24 etc..
| |