Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Searching for unprintable characters
From:   McCall, Glenn D

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).


Select the_problem_column, char2hexint(the_problem_column)
From the_problem_table

Hope this helps

Glenn Mc

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020