Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 19 Aug 2002 @ 15:38:42 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Unprintable characters
From:   Geoffrey Rommel

  How would I test for unprintable characters in a name column?  

Here's another idea, Karen. If you are sure that every character you're looking for is a tab, and the name column is defined as LATIN, you can use this:

where name_col like '250925'xc /* %, tab, % */

Unicode would require this:

where name_col like '002500090025'xc /* %, tab, % */

If you want to find any unprintable character, try this:

where substr(name_col, 1,1) < ' '
  or substr(name_col, 2,1) < ' '
  or substr(name_col, 3,1) < ' ' ... etc.

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