Archives of the TeradataForum

Message Posted: Tue, 16 Mar 2004 @ 17:19:21 GMT

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

Michael Larkins wrote:

Nope.

If you insert trailing blanks into a VarChar column, the blanks are *not* removed. Just try it.

You have to remove blanks explictly:

DROP TRAILING BLANKS within .FIELD -> CPU usage on the load node, probably less bytes over the network/smaller worktable

TRIM(TRAILING FROM :Inputcol) within INSERT -> CPU usage on the TD server, probably more bytes over the network/larger worktable

Dieter

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