Oninit cdi / Archive
Talk to an expert →

Re: concatenating strings

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

samir BADAOUI — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to samir BADAOUI
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

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 ! It would seem that what you want is to compare the first N characters of comp_colonneA to the entire length of comp_colonneB where N is the length of comp_colonneB, true? You cannot do that in 7.2x because the substring notation does not permit it, however, in 7.3x you can use the new substr() function: SELECT * FROM table WHERE SUBSTR( comp_colonneA, 1, length(comp_colonneB) ) = comp_colonneB; Art S. Kagel

Related threads