Archives of the TeradataForum

Message Posted: Fri, 30 Jun 2006 @ 08:54:45 GMT

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

Vivek:

It does not matter if you use CAST or change the attribute. If you are working with real data, you need to use the correct length. An integer can have 10 digits in it. You covered these. However, you seem to be ignoring the fact that an integer can be negative. If you use the correct length, it works.

     /*  should be varchar(11), not 10  */
     > sel *
     > From tt1,t1
     > Where TRIM (tt1.a (varchar(11))) =t1.a;

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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