Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2003 @ 22:50:33 GMT

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

Try this

Select the_problem_column, and_other_fields_of_interest
From the_problem_table
Where char2hexint(the_problem_column) = '0000';

Obviously substitute my silly table/column names for your table and column names.

You should also be able to use the where clause in a delete or an update if need be. You can also use char2hexint in the select to see what is in there (you don't need to fexp to MVS).

Eg:

Select the_problem_column, char2hexint(the_problem_column)
From the_problem_table

Hope this helps

Glenn Mc

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