 |
 |
Archives of the TeradataForum
Message Posted: Tue, 14 Aug 2007 @ 18:48:24 GMT
| 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.
Dieter
| |
