> 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.
>

Thanks, but I'm trying to use the CASE in a SELECT, not as part of
the code of a SP or Trigger.