Re: How to find International Characters in a column?

"Chocks" <chocks.k_at_gmail.com> writes:

> Hey ,
>
> We are using Oracle 9i DB . I have to find out the records which are
> having International characters in a given column. I read we can use
> reg_exp in Oracle 10g.
> Whether it is possible to find out this using PL/SQL . If any body
> could help me on this ?
>
> Thanks in advance
> Chocks.k.
>

You could do some translate magic like this:

select * from your_table
where

   translate(your_column,'*0123456789','*') is not null;

this on selects all rows that have your_column contain not only digits. You could similarly translate all wanted characters to null and see if there is a remainder.

Hope that helps,
Lothar

-- 
Lothar Armbrüster  | lothar.armbruester_at_t-online.de
Hauptstr. 26       |
65346 Eltville     |