Archives of the TeradataForum
Message Posted: Thu, 22 Nov 2002 @ 00:31:33 GMT
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 )=' '
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|