Archives of the TeradataForum

Message Posted: Fri, 03 Jun 2011 @ 14:33:41 GMT

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

Try this one:

     select length ('100')
          , length(100)
          , length (1000)
          , length (10000)
          , length (100000)
          , length (1000000)
          , length (100000000)
           length (1000000000)

Reported lengths

     3   4   6   6   11   11   11   11

An integer type has a fixed length.

Rgrds,

Bill Gregg

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