--- In firebird-support@yahoogroups.com, "legrand_legrand_63"
<grand.brun.63@...> wrote:

>
> Could you try this ?
>
> Select Numero,
> Sum(case concepto when 1 then cast(valor as float) else cast(0 as
> float) end)
> as Val1,
> Sum(case concepto when 80 then cast(valor as float) else cast(0 as
> float) end)
> as Val80,
> Sum(case concepto when 85 then cast(valor as float) else cast(0 as
> float) end)
> as Val85
> From Movtos
> group by numero
>
> Regards
> PAscal
>

Hi,

This work perfect.

Thank you!.