Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA16670 for ; Thu, 3 Sep 1998 14:44:40 -0400 (EDT) Received: by bjke.com; id NAA17859; Thu, 3 Sep 1998 13:44:33 -0500 (CDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmab17706; Thu, 3 Sep 98 13:44:21 -0500 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Thu, 3 Sep 1998 13:45:56 -0500 Message-ID: From: "Jackson, DeJuan" To: Fidelis Assis , owner-pgsql-sql@hub.org, pgsql-sql@postgreSQL.org Subject: RE: Resp: [SQL] Concatenation in selects Date: Thu, 3 Sep 1998 13:45:54 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain > select ltrim(first_name) || (' ' || ltrim(last_name)) as full_name > from > ... > > where "ltrim" is used only to convert both, first_time and > last_time, to text. I wish I could convert among string types > (bpchar, varchar and text) without any tricks, but it seems this > is not implemented yet. > Ever tried the cast() function? -DEJ