Archives of the TeradataForum

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

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

"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>>