At 03:29 PM 25-01-02 +0000, you wrote:

>Hi, I'm moving ( or trying to move) to IB / FB.
>
>The next SELECT is SQL Standard, but doesn't work in IB
>
>CASE
> WHEN s.status > 25 THEN 'Fine'
> ....
> ELSE 'xxx'
> END
>
>How can I write this operation in IB ?

You will need to use IF...THEN...[else] blocks.

>Are there another SQL Standard operators / expressions not supported
>in IB ?

Heaps. It's easier to look at what is there and work out what is missing. Sql standards tell you how to implement an SQL construct, if it is implemented. PSQL itself isn't subject to standards, it's vendor-specific.

CASE statements? Love 'em. It's on the Firebird drawing board, no clues about Borland's plans for IB.

Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________