>
> 1) The inner translate finds all the non-alphanumeric characters:
>
One slight problem with this is that it will also find all *national*
characters, but will convert them to lower case, and consequently
uppercase national characters in the source will NOT be filtered
out. Common problem when your mother language is English -
you just tend to forget there are other alphabets out there... :)
Obvious solution is to drop lower() and instead put all characters
you want to keep in both upper and lower case in the inner
translate.
--
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 - 10:03:11 CST
