Archives of the TeradataForum

Message Posted: Mon, 11 Jun 2007 @ 20:04:19 GMT

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

Use TRIM alongside w/ COALESCE AS

     coalesce(TRIM(field1),'').

Bear in mind that empty string is not a NULL field.

Thanks,

Vinay Bagare

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