> Hello,
>
> we're switching from Paradox to Firebird. Unfortunately we must use
> dialect 1.
>
> Now we have this problem:
>
> --->
>
> SELECT SOMETHING, colA*colB as PRICE
> FROM PRICES
> GROUP BY SOMETHING, colA*colB as PRICE
>
> <---
>
> does not work. I've tried several variations, but didn't find a
> solution.
>
> Is there any way to solve this problem?
>
> kind regards
> Uwe Keim
>

I doubt you'd want to group by the price anyway - there'd be very little
grouping
just GROUP BY SOMETHING will be effective
Alan