Identify invalid characters in table.

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 Received on Fri Jun 15 2007 - 03:15:54 CDT