Archives of the TeradataForum

Message Posted: Mon, 17 Nov 2003 @ 21:46:55 GMT

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

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

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