Re: non alpha characters cleaning strings ??

Floyd Wellershaus said: > Hello, > Is there any function in sql to facilitate the cleaning of a string to > get rid of all non-apha characters ? > For instance, if a Last_name is O'brian, it will return Obrian, or if the > lastname is Hally-Roma, it will return HallyRoma ? > > It would be basically, the sql way of doing 'tr -Cd '[:alpha:]'. Version? -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.