Re: Does somebody know a better way

Das Schaf wrote:

> In article <3DB042E9.C709AAD8_at_exesolutions.com>, dmorgan_at_exesolutions.com
> says...
> > SELECT TRANSLATE('test_string', 'A{|}~ !"#$%&''()*+,-./:;<=>?@[\]^_`', 'A')
> > FROM dual;
> >
> Thanks Daniel, I will be using your solution in preference to my own. However,
> its still an exclusionary device, I have to specify what to exclude. My perfect
> solution would be one that includes specified characters and excludes
> everything else, as that's the requirement I really have.
>
> Thanks for your attention to my problem,
> Chris

Six of one .... half a dozen of the other.

The result will be the same.

But the fewer things that need to be checked ... the better the performance. And the keep list is larger than the drop list.

Daniel Morgan Received on Fri Oct 18 2002 - 15:03:43 CDT