Archives of the TeradataForum

Message Posted: Thu, 06 Nov 2008 @ 19:14:00 GMT

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

The binary length of the string can be avoided by casting the value to some specific maximum characters.This will cause some additional characters spaces if some of the records are smaller than the maximum limit. The additional spaces can be removed by adding some constants at the end of the string in SQL as shown.

Eg:

     SELECT cast ( COLA||'|'||COLB||'|'||COLC||'zZzZzZ'  as (CHAR(100))

Using awk/shell script we can remove the constant zZzZzZ and the consequent spaces .

Amir

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