Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2004 @ 18:35:14 GMT

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

I have some low-values in a column and found them by using hashrow function. But how to select all the data where this column has low- values.

My select query is like this

     select hashrow(coulmn1), column1, length(column1) from dbname.tabl1
     where table_id=1

Result is like this

     HASHROW(column1)    column1          Characters(column1)
     00000000                             30

Thanks in advance,

Uma

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