Archives of the TeradataForum

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

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

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	Next>	Last>>