Replacing string and filtering non-ASCII characters

Tools & Utilities

Replacing string and filtering non-ASCII characters

Hi Everyone,

I am new to teradata. Can some one help me in solving the following.

1. I have some control and non-printable characters in data for the NAME (varchar2)column. I need to filter them.

Eg: Ran^Gdy or Ran^@dy --- Randy(required output).

2. If the NAME column contains NON-ASCII characters, filter out them.

Eg: Régis
Ãlafur Andri
Bérengère

I want to filter the records with data as mentioned above in NAME column (using WHERE condition)in select statement .

Can any one help me out with this?

Thanks in advance....