Archives of the TeradataForum

Message Posted: Fri, 26 Jul 2002 @ 09:03:25 GMT

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

We have a similar ID field which is DECIMAL(18,0) and this is also a bit dodgy in Queryman. Basically, if you Select it straight from the table, Queryman will do some wierd rounding on the number, consequently, if you copy and paste this number into another query you will get unexpected results. If you want to see it "as it is", then try casting it into a CHAR(20).

This only affects the value of the number displayed not the value 'inside' the SQL. i.e. if you do something like;

SELECT * FROM BBB WHERE BBB.ID_NUM IN (SELECT AAA.ID_NUM FROM AAA);

That will still give you expected results.

Did you copy the '333333333333333500' out of a Queryman answerset? If so, you may find that this record doesn't exist and the actual number is something like '333333333333333521'

LV

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