IIF or CASE

Article View: borland.public.interbase.sql

Article #11286

Back to borland.public.interbase.sql Previous Next

#11286

From: nitebird
Date: Tue, 03 Dec 2002 05:12

17 lines
1384 bytes

Hi all,

I'm able to use IIF in FoxPro ODBC and it generates really nice result. The sample code is as follow:

SELECT b.category,
  SUM (iif(a.fperiod=1, qty*1 , 0)) as Jan,
  SUM (iif(a.fperiod=2, qty*1 , 0)) as Feb,
  SUM (iif(a.fperiod=3, qty*1 , 0)) as Mac,
FROM aTable
bil))/4)
Group by category

Can I do the same in IB?
Is there any equivalent to IIF or CASE in IB?

TIA

Technical Details

Message-ID: <3dec3d48$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!gestalt.direcpc.com!news.stealth.net!news.stealth.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,5f6f676ee9638e28,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-02 21:15:34 PST
From: "nitebird" <nitebird@time.net.my>
Sender: "nitebird" <nitebird@time.net.my>
Reply-To: "nitebird" <nitebird@time.net.my>
Subject: IIF or CASE
Newsgroups: borland.public.interbase.sql
X-User-Info: 161.142.100.85 161.142.100.85    
X-Forwarded-For: 61.6.143.140
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3dec3d48$1@newsgroups.borland.com>
Date: 2 Dec 2002 21:12:40 -0800
X-Trace: newsgroups.borland.com 1038892360 207.105.83.65 (2 Dec 2002 21:12:40 -0800)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!gestalt.direcpc.com!news.stealth.net!news.stealth.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail