Re: REPLACE function - ?

tomcaml@yahoo.com said: > hi all > > > This is what I am trying to do: Have a look at the regexp bladelet on the DataBlade section of the Informix section of the developerworx section of the IBM webshite. > Select REPLACE(name,'[^[:alphanum:]]','') as New_Name, name from > company > > > > I want to replace ANYTHING that is not alpha-numeric in the name > > > i am guessing what is needed is a custom stored proc but just thought i > would check first.....Thanks > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list