Re: Still need Informix Help!

}From: slitel@cadre.com (Stuart Litel) }Subject: Still need Informix Help! }Date: 3 Dec 93 18:06:03 GMT }X-Informix-List-Id: <news.5020> } }My original question.... } }Has anyone seen the syntax with either a double pipe ("||") or a single }pipe ("|") between the two selected fields.. I've seen this before and }used it before (or something like it) and do not recall the exact syntax. }The original question I still cannot find a solution..... The 5.0x Engines support the || operator as string concatenation. SELECT Owner || "." || TabName FROM SysTables; Of course, the owner string is not clipped before the concatenation takes place. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>