Archives of the TeradataForum

Message Posted: Sun, 20 Aug 2006 @ 10:15:46 GMT

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

If you find nothing else working, something that you may be able to consider is 'forcing' the retention of the spaces with using something like this in the place of YourColumn when converting the data..

     SUBSTR(YourColumn,1,INDEX(YourColumn||'#$#', '#$#'))

Johannes de Wet
UnumProvident Corportaion

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