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. > > -- > Mike Given two fixed length character fields f1 and f2 in table t1 the syntax would be: select f1 || f2 from t1; If you wish to trim the strings then something like: select trim(f1) || trim(f2) from t1; All information found on pg 547 & 580 of the Informix Guide to SQL Syntax, version 7.1. Won't say that it will work for any earlier versions. John Gose