Re: Thanks. nm

Article View: borland.public.interbase.sql

Article #11078

Back to borland.public.interbase.sql Previous Next

#11078

From: Martijn Tonies
Date: Fri, 20 Dec 2002 16:05

33 lines
1845 bytes

> > > 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

Do note that if one of the columns is NULL, the result ends
up being NULL as well.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Technical Details

Message-ID: <3e033f0e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!sac.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e0338c4@newsgroups.borland.com> <3E033A99.1FF3AA44@mindspring.com> <3e033c7e$1@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:30 PST
From: "Martijn Tonies" <m.tonies@upscene_remove.com>
Newsgroups: borland.public.interbase.sql
References: <3e0338c4@newsgroups.borland.com> <3E033A99.1FF3AA44@mindspring.com> <3e033c7e$1@newsgroups.borland.com>
Subject: Re: Thanks. nm
Date: Fri, 20 Dec 2002 17:05:29 +0100
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.238.179.102
Message-ID: <3e033f0e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040400142 212.238.179.102 (20 Dec 2002 08:02:22 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!sac.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message