Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 14:58:25 GMT

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

<-- 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.

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