Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Samir
How about
select col1 || col2 from ...
or if you need to remove blanks from the end of col1 and col2
select TRIM(col1) || TRIM(col2) from ...
or you could use the SUBSTR function.
HTH
Sujit
samir BADAOUI <samir_badaoui@hotmail.com> on 08/11/99 05:36:46 AM
To: informix-list@iiug.org
cc: (bcc: Sujit Pal)
Subject: concatenating strings
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.