Re: concatenating strings
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