![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 14 Sep 2007 @ 14:05:32 GMT
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.
| |