Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2008 @ 14:58:25 GMT
<-- Anonymously Posted: Wed, 19 Mar 2008 09:53 -->
I want to equate a blank (non-null, non-spaces) value with a Null value so they don't produce results in a minus query.
Any suggestions? I have a translate function but don't think there's an ascii value for Blank ( not x'20' for space).
if I could translate blank to * on one side of the minus, and coalesce Null, * on the other side of the minus, I'd be all set.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|