Archives of the TeradataForum

Message Posted: Thu, 22 Nov 2002 @ 00:31:33 GMT

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

wgr,

You might defer the null check until values() clause. Since you appear to be an all or nothing check for low values, you may be able to use TRIM.

,case when TRIM ( TRAILING '00'XCF FROM :IN_STR_ADR_LN_1 )=' '
then null
else :IN_STR_ADR_LN_1 End

I also have some SyncSort code around somewhere that can convert the low values to spaces before loading, if you want that.

Hope this may spark some ideas.

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