Thanks. nm

Article View: borland.public.interbase.sql

Article #11077

Back to borland.public.interbase.sql Previous Next

#11077

From: DP
Date: Fri, 20 Dec 2002 15:51

38 lines
1971 bytes


"Jeff Overcash (TeamB)" <jeffovercash@mindspring.com> wrote in message
news:3E033A99.1FF3AA44@mindspring.com...
>
>
> 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: <3e033c7e$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!nntp.abs.net!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>

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: "DP" <daveperkins@_woo-hoo"-'#-bigfoot.com>
Newsgroups: borland.public.interbase.sql
References: <3e0338c4@newsgroups.borland.com> <3E033A99.1FF3AA44@mindspring.com>
Subject: Thanks. nm
Date: Fri, 20 Dec 2002 15:51:52 -0000
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 217.155.64.69
Message-ID: <3e033c7e$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040399486 217.155.64.69 (20 Dec 2002 07:51:26 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!nntp.abs.net!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