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