Archives of the TeradataForum

Message Posted: Mon, 01 Nov 2004 @ 16:34:07 GMT

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

     select char2hexint(column1), length(column1) from dbname.tabl1
      where substr(column1, 1,4) = '00000000'xc;  /* if column1 is CHAR */
      where substr(column1, 1,4) = '00000000'xb;  /* if column1 is BYTE */

You don't have to check exactly 4 bytes, of course; you can check all of them, or as many as you need.

She means bytes in which all bits are off (0). In Cobol, these are called LOW-VALUES because they sort lower than any other value.

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