I have a requirement whic says "NULL IF UNREADABLE" . Can anyone please help me how i can identify the UNREADABLE charecters in teradata.
thanks in advance ,
You can use the SQL like
case when translate_chk(col1 using unicode_to_latin) <> 0 then NULL else col1 end
to nullify non-readable characters .