Re: non alpha characters cleaning strings ??

Posted in 2007

Floyd Wellershaus — Fri, 16 Mar 2007 16:29:52 -0700 (PDT) — source: Usenet: comp.databases.informix

IDS10.0.uc5 ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: Obnoxio The Clown <obnoxio@serendipita.com> To: Floyd Wellershaus <fwellers@yahoo.com> Cc: informix-list@iiug.org Sent: Friday, March 16, 2007 2:47:14 PM Subject: 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.