Archives of the TeradataForum

Message Posted: Thu, 18 Sep 2003 @ 11:27:59 GMT

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

I think this should point out the position number of the invalid character:

Select   ColA
,     Translate_Chk(ColA using Latin_To_Unicode)
,     ColB
,     Translate_Chk(ColB using Latin_To_Unicode)
...
FRom  TableName
Where (
      Translate_Chk(ColA using Latin_To_Unicode) <> 0
or    Translate_Chk(ColA using Latin_To_Unicode) <> 0
or    ....
      )

Let me know if it works, it has been a while since I've tested this function, and I cannot seem to recreate a test set with an invalid character to prove the theory.

Hope this helps,

Clay

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