CASE Example

SELECT MyField1, MyField2, CASE WHEN MyField3 = 0 THEN 'Zero' WHEN
MyField3 = 1 THEN 'One' ELSE 'Not Zero or One' END FROM MyTable

Peter Gore

-----Original Message-----
From: Mark Patterson [mailto:mpatterson@...]
Sent: 15 May 2003 03:35
To: IB Support
Subject: [ib-support] SQL reference for changes in 1.5?


Hi,

There are a few enhancements to the SQL that 1.5 can cope with. Are
these
explained somewhere? I'd like to be able to use the new features. E.g.
CASE in
the SELECT statement, but I'm not sure of the syntax. Is there a
reference
on-line? And a list of the differences?

Regards,

Mark



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=249982.3179269.4495679.1261774/D=egroupweb/S=1705
115386:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=5
56&lineid=3179269&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=249982.3179269.4495679.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=183445863>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]