non alpha characters cleaning strings ??

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:]'. Thanks, Floyd ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/