Re: Urgent

Posted in 1999

Francisco Huezo — Tue, 22 Jun 1999 21:13:54 -0600 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------E961702A84BD947AFE08CACC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Nadella. Sorry. But Informix only supports character functions since IDS 7.3. However, there stores procedure does. I saw ones in internet but I don't remeber where. Somehow, my suggestion is you work string on client-side or migrate 7.3. l_nadella@yahoo.com wrote: > Hello All > I am a newbie to Informix 7.2 but familiar with Oracle. Is there an > equivalent for SUBSTR function in Informix? I need to trim the first > four characters from the values stored in a column. Also I need to > convert any character which is not alphanumeric(/:, etc.) to a hyphen. > Any Ideas??? > > Nadella > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. --------------E961702A84BD947AFE08CACC Content-Type: text/x-vcard; charset=us-ascii; name="fhuezo.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Francisco Huezo Content-Disposition: attachment; filename="fhuezo.vcf" begin:vcard n:Huezo Saravia;Francisco Armando tel;pager:(503) 298 1122 unidad 41772, fhuezo@mail.televip.com.sv tel;cell:(503) 830 6974 tel;fax:(503) 226 81 84 tel;work:(503) 224 37 00 ext 380 x-mozilla-html:FALSE org:Ministerio de Hacienda;Proyecto SAFI version:2.1 email;internet:fhuezo@mh.gob.sv title:Administrador de Base de Datos adr;quoted-printable:;;Cond. Tres Torres, Torre 2, Nivel 8.=0D=0A;San Salvador;San Salvador;;El Salvador fn:Francisco Huezo end:vcard --------------E961702A84BD947AFE08CACC--