Re: Identify invalid characters in table.

On 15 jun, 10:15, t538449 <kenneth.osenbr..._at_telenor.com> wrote:
> Hi,
>
> I am trying to identify invalid characters in a table. The valid
> characters are stored within a table which the table I want to find
> invalid characters are matched upon. The table pub_symbol consists of
> all valid characters (chr(value)), while the table address is the
> table I want to check. This is what I have so far:
>
> select addrsurname from address minus select a.addrsurname from
> address a, pub_symbol p where instr(a.addrsurname, p.pub_symbol)<>0;
>
> This (I hope) will give me all addrsurname which contain any
> characters not listed in pub_symbol. Does anyone have any propositions
> on how to optimize this,- or another way of achieving the result on?
>
> Thanks,
> Kenneth

You might want to take a look at TRANSLATE function.

HTH. Cheers.

Carlos. Received on Fri Jun 15 2007 - 03:56:20 CDT