> Is there any way to emulate oracle decode or sql server case features?

Firebird v1.5 includes support for CASE statement.

--
Sean Leyne

- FirebirdSQL Foundation, Sponsor - Silver Level
- FirebirdSQL Foundation, Member
- FirebirdSQL Project Admin (one of many)
http://www.FirebirdSQL.org