Re: concatenating strings

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