Re: Combining varchars to return one varchar

Article View: borland.public.interbase.sql

Article #11075

Back to borland.public.interbase.sql Previous Next

#11075

From: Jeff Overcash (TeamB)
Date: Fri, 20 Dec 2002 15:43

34 lines
1908 bytes


DP, -'#-bigfoot.com> wrote:
> 
> Hello
> 
> Rather than doing :
> 
>   Select title, fname, lname
>     from contacts
> 
> what's the correct syntax for doing something like this:
> 
>     select (title+' '+fname+' '+lname) as fullname
>      from contacts
> 
> I'm assuming the above is not correct.
> 

    select (title || ' ' || fname || ' ' || lname) as fullname
     from contacts

> TIA
> 
> David

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus.            (Fish)

Technical Details

Message-ID: <3E033A99.1FF3AA44@mindspring.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.70.MISMATCH!feed3.newsreader.com!newsreader.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e0338c4@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,96ab11eb7f71fbb3
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-20 08:03:29 PST
Message-ID: <3E033A99.1FF3AA44@mindspring.com>
Date: Fri, 20 Dec 2002 10:43:21 -0500
From: "Jeff Overcash (TeamB)" <jeffovercash@mindspring.com>
Organization: TeamB
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Combining varchars to return one varchar
References: <3e0338c4@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66.245.8.222
X-Trace: newsgroups.borland.com 1040398822 66.245.8.222 (20 Dec 2002 07:40:22 -0800)
Lines: 34
X-Authenticated-User: overcash
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.70.MISMATCH!feed3.newsreader.com!newsreader.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message