Re: concatenating strings
You could try using the the substr function: substr(comp_colonneA, 1, length(comp_colonneB))=comp_colonneB Of course if you are working with a new enough server that supports this function. Best Regards, Octav On Wed, Aug 11, 1999 at 06:04:37AM -0700, samir BADAOUI wrote: > > yes, that wxactly what I want to do, thanks. > Now I have a nother question. I want to include in my where statement a > condition like : > comp_colonneA[1,length(comp_colonneB)]=comp_colonneB > I mean comp_colonneB is a part of comp_colonneA where comp_colonneA and > comp_colonneB are aliases (comp_colonneA=col1||col2||col3.., > comp_colonneB=col11|col12|col13..) > Could any body help me please ! > Thanks > > >From: Octav Chiriac <com@netinfo-moldova.com> > >Reply-To: com@netinfo-moldova.com > >To: samir BADAOUI <samir_badaoui@hotmail.com> > >CC: informix-list@iiug.org > >Subject: Re: concatenating strings > >Date: Wed, 11 Aug 1999 15:47:02 +0300 > > > >Do you mean: > > select trim(col1) || trim(col2) ... ? > > > >Best Regards, > >Octav > > > >On Wed, Aug 11, 1999 at 05:36:46AM -0700, samir BADAOUI wrote: > > > Hi friends, > > > Can any one help me to performe a query to select a char colomns > > > concatenated. I want to do someting like this : > > > select col1[1,length(col1)]||col2[1,length(col2)]|| > > > from ... > > > where ... > > > the previous query dont work, but it just give you an idea what I want > >to > > > do. > > > Thanks ! > > > > > > > > > >From: "Art S. Kagel" <kagel@bloomberg.net> > > > >Reply-To: kagel@bloomberg.net > > > >To: informix-list@iiug.org > > > >Subject: Re: Informix NET > > > >Date: Tue, 03 Aug 1999 17:22:42 -0400 > > > > > > > >it is now called iConnect. It is available for download for free now. > > > >Now include ODBC also. > > > > > > > >Art S. Kagel > > > > > > > >"Muhammad Usman" wrote: > > > > > > > > > > Hi > > > > > > > > > > Is Informix NET client for Windows 95/98/NT available for download. > >I > > > >could > > > > > not find in http://www.intraware.com website. > > > > > Does anybody have any idea? > > > > > > > > > > Thanks in advance. > > > > > > > > > > regards > > > > > > > > > > Muhammad Usman > > > > > musman@iffco.com > > > > > > > > > ______________________________________________________ > > > Get Your Private, Free Email at http://www.hotmail.com > >-- > >Octav Chiriac Phone: (373) 2 22 99 67 > >NetInfo S.R.L. Fax: (373) 2 21 36 59 > >Chisinau (373) 2 22 84 88 > >Moldova, Republic of mailto:com@netinfo-moldova.com > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com