Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 11:24:39 GMT

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

Hi,

This might help you out.. If you have any nulls in your column

     substr(TRIM(COALESCE(coulun name,''))x,y)

Thanks,

Vijay kumar.R

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