donjules2k wrote:

>Can firebird return a pivot or crosstab table?
>
>Does it support using case or if statements in field names?
>
>such as:
>
>select (case field1
> when 'hello' then field2
> else field3),
> field4,
> field5
>from mytable
>
>
>OR
>
>
>select (if field1 = 'hello' then
> field2
> else
> field3),
> field4,
> field5
>from mytable
>
>
>Thanks
>
>Giulio
>
>

Giulio,

Take a look at firebird 1.5 release notes, there is a "case" expression
that will solve your problem...

You could make a pivot table or crosstab in your client application.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br