If you are using Firebird 1.5 beta you can use CASE statement.

select MyField, case MyField2 when ‘FieldValue’ then 'Found It' else '
' end from MyTable

Peter Gore

-----Original Message-----
From: José M.Llanes [mailto:jol@...]
Sent: 09 April 2003 22:06
To: ib-support@yahoogroups.com
Subject: [ib-support] Migrating MS-SQL7 to FireBird

Hi,
I' need migrating "iif()" function from sql7 to firebird,
Wath function similar i can use in ib_udf ?

Thanks
José







Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=246920.2960106.4328965.1728375/D=egroupweb/S=1705
115386:HM/A=1513703/R=0/*http:/www.gotomypc.com/u/tr/yh/cpm/grp/300_06F/
g22lp?Target=mm/g22lp.tmpl>


<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.1728375/D=egrou
pmail/S=:HM/A=1513703/rand=644776575>

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



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


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