Re: How can I convert strings efficiently?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 2 Apr 2003 17:07:06 +0400
Message-ID: <b6en9u$hjp$1@babylon.agtel.net>

> current environment: 8.1.7.0.0 Enterprise Edition.
>
> I've a little problem I can't solve nicely. I want
> to replace everything in a string with NULL
> that isn't a letter or a number.

Try using TRANSLATE() for this. For example, this way:

translate(mystring, '0[chars here will be removed]', '0')

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Wed Apr 02 2003 - 07:07:06 CST