Concatenation

Article View: borland.public.interbase.sql

Article #530

Back to borland.public.interbase.sql Previous Next

#530

From: Alain
Date: Fri, 16 Nov 2007 11:12

2 lines
1025 bytes

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

Technical Details

Message-ID: <473d7b05@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,36e9dbfd49323fb6
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Alain" <alainbastien@gmail.com>
Newsgroups: borland.public.interbase.sql
Subject: Concatenation
Date: Fri, 16 Nov 2007 15:12:08 +0400
Lines: 4
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 202.123.15.120
Message-ID: <473d7b05@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1195211525 202.123.15.120 (16 Nov 2007 03:12:05 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail