Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2007 @ 14:05:32 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: To check for Non ASCII in the data
From:   Geoffrey Rommel

  But I would like to give the column of a table and check if the values in the column have any non ASCII values.  

I'll assume that (a) you want to accomplish this without using a UDF (but why??) and (b) this is a LATIN column, not Unicode. Non-ASCII, then, just means that one of the characters is x'80' or greater. So you could do this:

     where substr(suspect_column, 1,1) >= '80'xc
      or substr(suspect_column, 2,1) >= '80'xc
      or substr(suspect_column, 3,1) >= '80'xc
      or ... etc.

I'd rather go with the UDF.

  <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