Archives of the TeradataForum
Message Posted: Wed, 15 Aug 2007 @ 17:06:00 GMT
"These Fields" are the table fields or the between values?
Because if you cast the between values to integer, It should work.
Values(1,2,3,35); select * from t1 where the_value between '1' and '4';
select * from t1 where the_value between cast('1' as integer) and cast('4' as integer);
Why you can't cast the values to integer?
Hope this helps,
Castelli, Emanuel Alejandro
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|