 |
 |
Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 11:18:07 GMT
| Subj: | | Re: Null values in a select |
| |
| From: | | Victor Sokovin |
| | I got the expected results when I replaced all the nulls with a space. the first query is selecting all the rows from cust_current table as
the alter_cust_id has some value in current table and a space in prev table. | |
You can use a similar trick in the SQL by using the COALESCE function, the counterpart of Oracle NVL. Even if the table has NULLs, which is
sometimes unavoidable, you can "correct" them on the fly. Of course, you need to substitute NULLs by some value which cannot normally occur in the
table.
Regards,
Victor
| |
