Re: String Concat in SQL?

Michael S. Verrilli wrote: > > Anyone know the syntax (if there is one) for concatting strings > in SQL? I can do it in ACE but it would be a lot easier to > update tables from SQL. > > Thanks in advance for the help. SELECT columna || columnb would concatenate columna and columnb, including any trailing blank spaces in columna. In more recent versions (7.1?) of the database: SELECT trim(columna) || " " || trim(columnb) would concatenate the columns and put one space between them. Try any SELECT with trim(); if you get a syntax error pointing to trim, your version of the database doesn't have the feature. > > -- > Mike -- //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer