|
|
Archives of the TeradataForum
Message Posted: Mon, 17 Nov 2003 @ 21:46:55 GMT
Subj: | | Re: Empty Value |
|
From: | | Frank C. Martinez IV |
Try:
select HarryPotterInd, CHAR2HEXINT(HarryPotterInd), count(*)
from t1
where HarryPotterInd IS NOT NULL
group by 1;
If you see something other than "2020" in the second column (uh, that is, if you see 20/20. Nevermind!) that means you've got some
sort of OTHER binary data in the field. Betcha just loaded it from the source with doing any fixing. Gotta watch those dem Dementors,
they're everywhere.
iv
| |