Article View: borland.public.interbase.sql
Article #11081Re: ISNULL
From: Craig Stuntz TeamB
Date: Fri, 20 Dec 2002 17:30
Date: Fri, 20 Dec 2002 17:30
22 lines
1897 bytes
1897 bytes
In article <3e01c7fa.6278187@newsgroups.borland.com>, nomail@sorry says... > On Mon, 18 Nov 2002 13:21:06 -0500, Craig Stuntz [TeamB] > <cstuntz@nospamplease.com (but use vertexsoftware to email)> wrote: > > >In article <3dd926d5@newsgroups.borland.com>, ariannaduo@actionlabs.it > >says... > >> How can I do it? > >> > > The same way, but you'll need four SELECTs in the SQL. > > don't you think that's bad... > Less than ideal, but it does work. I agree that COALESCE would be a good SQL feature to add. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<MPG.186d1da84481566c98a46b@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3dd91ae9@newsgroups.borland.com> <MPG.1842ebcd1e9d0c2598a19c@newsgroups.borland.com> <3dd926d5@newsgroups.borland.com> <MPG.1842f94e1c123bba98a19f@newsgroups.borland.com> <3e01c7fa.6278187@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,fb97e03104bab9e2 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-20 09:32:06 PST From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> Newsgroups: borland.public.interbase.sql Subject: Re: ISNULL Date: Fri, 20 Dec 2002 12:30:06 -0500 Message-ID: <MPG.186d1da84481566c98a46b@newsgroups.borland.com> References: <3dd91ae9@newsgroups.borland.com> <MPG.1842ebcd1e9d0c2598a19c@newsgroups.borland.com> <3dd926d5@newsgroups.borland.com> <MPG.1842f94e1c123bba98a19f@newsgroups.borland.com> <3e01c7fa.6278187@newsgroups.borland.com> Organization: Vertex Systems Corporation X-Newsreader: MicroPlanet Gravity v2.60 NNTP-Posting-Host: 65.86.87.242 X-Trace: newsgroups.borland.com 1040405410 65.86.87.242 (20 Dec 2002 09:30:10 -0800) Lines: 22 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail