Re: Concatenation

Article View: borland.public.interbase.sql

Article #529

Back to borland.public.interbase.sql Previous Next

#529

From: SimonW
Date: Fri, 16 Nov 2007 11:17

6 lines
1058 bytes

Alain wrote:
> Hi,I wish to concatenate two fields in oneSELECT (lname + ', ' + fname) AS 
> Name from clientsThe above is not working ! How to ?Thanks 
> 
> 
SELECT (lname || ', ' || fname) AS Name

Technical Details

Message-ID: <473d7d36$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <473d7b05@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,36e9dbfd49323fb6,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 16 Nov 2007 11:17:14 +0000
From: SimonW <Simon@nospam.co.uk>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Concatenation
References: <473d7b05@newsgroups.borland.com>
In-Reply-To: <473d7b05@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.155.0.135
Message-ID: <473d7d36$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1195212086 81.155.0.135 (16 Nov 2007 03:21:26 -0700)
Lines: 6
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message