Archives of the TeradataForum

Message Posted: Thu, 25 Apr 2002 @ 19:37:57 GMT

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

Use the TRIM function in your insert, you can specify which character to remove:

trim(both from trim(both '"' from HierarchyMain) )

Dieter

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